var data = from country in db.GetTable().Where(c=>c.Allowed) let totalTeams = country.Teams.Count() let teamsWithoutOwner = country.Teams.Count(t=>t.OwnerId != 0) select new CountryTeamsInfo { CountryId = country.Id, TeamsTotal = totalTeams, TeamsWithoutOwnerFree = teamsWithoutOwnerFree };