linq语法

LINQPad4.zip------linq转sql文件

一：where 嵌套查询

var q=from p in db.ParkingSpace 

join uw in db.sys_user_web on p.yardNumber equals uw.yardNumber

where (from u in db.sys_user.Where(c => (flag == true ? true : c.account == "1646"))

group u by u.account into u select u.Key).Contains(uw.account) select p;