linq
coder i++
coder i++分享一下 ,记录一下
展开
-
C# linq left join
左连接查询seleft a.*,b.column1,b.column2 from aleft join bon a.id = b.idlinq双表,多表连接查询var list = from x in db.lefttable join y in db.righttable on x.id equals y.id into temp from tt in temp.DefaultIfEmpty() select new res {name=x.name,value=原创 2021-08-06 17:01:46 · 2797 阅读 · 0 评论 -
C# linq join
1、inner joinSELECT1 AS `C1`, `Extent1`.`code`, `Extent1`.`name`FROM `sg` AS `Extent1` INNER JOIN `cg` AS `Extent2` ON `Extent1`.`code` = `Extent2`.`code` **INNER JOIN **2、left outer joinSELECT`Project1`.`id`, `Project1`.`code`, `Project1`原创 2021-08-27 11:06:06 · 1160 阅读 · 0 评论 -
C# linq group by
好久不用,忘了 记一下//get data from db List<ModelClass> source = new List<ModelClass>();//单一条件分组var sc1 = from sf in source group sf by sf.Name;//多个条件分组var sc2 = from sf in source group sf by new { sf.Name,sf.Price,sf.Amount}原创 2021-05-25 09:09:06 · 1101 阅读 · 0 评论