Click here to Skip to main content
15,792,870 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
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
Posted

 
Share this answer
 
Comments
saifullahiit 22-Sep-14 6:54am    
i have tried this one but could not find the solution
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[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900