深入解释sql运算符 ALL()、ANY()、Exits()、Not Exits()
[tblTGOCustomer]表列:[No][tblAccount]表列:[CUSTOMER_ID]Linq:IEnumerable customerRows = db.TGOCustomerTable.Where(a => db.AccountTable.All(b => b.CUSTOMER_ID != a.No)).OrderBy(a=>a.No);生成sql:SELECT *FROM [dbo].[tblTGOCustomer] AS [t0]WHERE NOT (EXISTS( SELEC
原创
2010-12-03 16:37:00 ·
937 阅读 ·
0 评论