http://stackoverflow.com/questions/10203191

var data =
from country in db.GetTable<Country>().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
};