Nov 28, 2016 01:46 PM|Adam-M|LINK
I need to construct a LINQ query to achieve the following:
Imagine an SQL table (dbo.projects) which contains a "Username" field, the ID of which is linked to another table (dbo.tasks) containing the ProjectID.
For each distinct user in projects, I need to return the username, and a count of the total tasks they've created.
So from the above user1 has three tasks, user2 has two and user3 has one task while user4 has none. How would I go about creating this as a LINQ query?
Thanks in advance