这个sql用linq怎么写

Question

本帖最后由 ameba_h 于 2009-07-16 00:07:53 编辑

Answer 1

DataContext nw=new DataContext();
var lists=from c in nw.albumlist let rowCounts=(from d in nw.pictures where d.pid==c.pid select d).Count()  select new{ pid=c.pid,albumname=c.albumname,createdate=c.createdate,crowCounts=rowCounts};

Answer 2

DataContext nw=new DataContext();
var lists=from c in nw.albumlist let rowCounts=(from d in nw.pictures where d.pid==c.pid select d).Count()  select new{ pid=c.pid,albumname=c.albumname,createdate=c.createdate,crowCounts=rowCounts};