摘要: 1. Concat 单列Concatvar expr = (from p in context.Products select p.ProductName) .Concat( from c in context.Categories... 阅读全文
posted @ 2014-10-25 19:40 libingql 阅读(4682) 评论(0) 推荐(0) 编辑
摘要: 1. Any 返回没有Product的Categoryvar expr = from c in context.Categories where !c.Products.Any() select c;SELECT [Extent1].[Categ... 阅读全文
posted @ 2014-10-25 18:52 libingql 阅读(9637) 评论(0) 推荐(0) 编辑
摘要: 1. 简单形式var expr = from p in context.Products group p by p.CategoryID into g select g;foreach (var item in expr){ Console.WriteL... 阅读全文
posted @ 2014-10-25 11:01 libingql 阅读(17544) 评论(4) 推荐(2) 编辑