So I have a Linq ro SQL question.
I have this LINQ query.
Which works. Just that for rows where the count is 0 the row is not returned at all.
How would I get it to return a row with 0 as the count value?
I have this LINQ query.
Code:
(from a in Nurses
join w in Wards on a.NurseWardAssigned equals w.WardID
group w by w.WardName into nursesCount
select new
{
WardAssigned = nursesCount.Key,
NumberNurses = nursesCount.Count()
});
Which works. Just that for rows where the count is 0 the row is not returned at all.
How would I get it to return a row with 0 as the count value?