Get just Count values from EF

Question

I have a People table, I want a method that return one Person by id, with numbers of Cars, number of houses, etc.

I need to Load this tables together? I see SQL generated by EF, is a monster.

Ex:

public Person Get()
{
    return context.People.Include("Cars").Include("Houses").Where(x=> x.Id = 1).First();
}

My view use this:

Name: <%= people.Name%>
Cars: <%= people.Cars.Count%>
Houses: <%= people.Houses.Count%>

Answer 1

You can do this

var result = (
   from p in ctx.People
   where p.Id == 1
   select new {
      Person = p, 
      Cars = p.Cars.Count(), 
      Houses = p.Houses.Count()
   }).FirstOrDefault();

Which will just bring back the counts.