CODEWITHSUNDEEP
c#linqentity-framework
roeland
roeland

Reputation: 6336

Linq to Entities count subquery?

I'm trying to do this query in linq to entities (EF4)

select Header.Id, 
 (select count(*) 
  from Detail 
  where Header.Id = Detail.headerId) detailcount
from Header

This won't work because it's not allowed in EF:
(Header and Detail are EntityObjects)

from h in context.Header
select new Header
    {
        Id = h.Id,
        DetailCount = (from d in context.Detail 
                       where d.headerId = p.Id select d).Count()
    }

DetailCount is a new property I added on the Detail Entity (partial class)

The above Linq query doesn't work because I cannot project onto a mapped entity:
The entity cannot be constructed in a LINQ to Entities query

Is there an other way of doing this?

Upvotes: 4

Views: 2862

Answers (2)

roeland
roeland

Reputation: 6336

I worked around this by using annonymous types.

Upvotes: 0

Pranay Rana
Pranay Rana

Reputation: 176896

below will do you task because both are related entities 

from h in context.Header
select new Header
    {
        Id = h.Id,
        detailCount = h.Detail.Count()
    }

Upvotes: 3

Related Questions