SQL Query to LINQ Conversion

Feb 2 2018 12:46 AM

Please provide me with the conversion of below SQL query to LINQ

select COUNT(rg.TagId), t.Name, r.Id,r.Name from ResourcesTag rg

inner join Tag t on rg.TagId = t.Id

inner join Resources r on rg.ResourceId =r.Id

group by rg.TagId,t.Name,r.Id,r.Name

order by COUNT(rg.TagId) desc

Answers (1)

use of First and FirstOrDefault