LINQ SELECT COUNT(*) AND EmployeeId

Question

Hi,

I have a table like below:

EmployeeId
EmployeeName

RequestId
RequestName

EmployeeId
RequestId

I need to a to assign requests in a sequential fashion(those who has mininum number of requests).

Can I know how to get employee who has minimum requests using linq???

Thanks, Mahesh

Answer 1

Assuming the class containing EmployeeID and RequestID (the third table) is named "Foo", it could be

(from f in db.Foos
 group by f.EmployeeID into g
 orderby g.Count()
 select new { f.EmployeeID, g.Count() }).First()

This is drycoded and may be wrong. =)