从SQL查询转换为Linq查询 [英] Convert from SQL query to Linq Query

问题描述

Can somebody please change this query for me to Linq

SELECT Causes.CauseTitle,COUNT(Calender.CauseID) AS NumberOfOccurance FROM Calender LEFT JOIN Causes ON Calender.CauseID=Causes.CauseID GROUP BY CauseTitle;

Thanks in advance

推荐答案

< a href =http://stackoverflow.com/questions/296972/sql-to-linq-tool> Take Linquer [ ^ ]

这是一个完美的例子供您参考 LINQ加入运算符 - 左外连接示例 [ ^ ]



但这里是完成 LINQ refence网站 [ ^ ]

Here is a perfect example for you to use as a reference LINQ Join Operator - Left outer Join Example[^]

But here is the complete LINQ refence site[^]

这篇关于从SQL查询转换为Linq查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！