Requête SQL Server en requête Linq

Bonjour,
pouvez vous m'aider à transformer ma requête sql server en Linq :

Code:

---

1 2 3 4 5 6 7 8 9 10 11

select Site,Libellé,(select count(*) from Staxe where Sites.Site = Staxe.Site and [Date_Comm]='28/09/2016') as NbreAppelSortant , (select count(*) from Staxe where Sites.Site = Staxe.Site and [Date_Comm]='28/09/2016' and [Nature_Comm]='M') as NbreAppelSortantGsm, (select count(*) from Staxe where Sites.Site = Staxe.Site and [Date_Comm]='28/09/2016' and [Nature_Comm]='L') as NbreAppelSortantLocaux, (select count(*) from Staxe where Sites.Site = Staxe.Site and [Date_Comm]='28/09/2016' and [Nature_Comm]='N') as NbreAppelSortantNationnaux, (select count(*) from Staxe where Sites.Site = Staxe.Site and [Date_Comm]='28/09/2016' and [Nature_Comm]='I') as NbreAppelSortantInternationnaux from Sites

---

Je n'ai pas testé, mais ça ressemble à ceci :

Code:

---

1 2 3 4 5 6 7 8 9 10 11 12 13

db.Sites.SelectMany(s => db.Taxes .Where(t => t.Site == s.Site && t.Date_Comm == new DateTime('28/09/2016')) .DefaultIfEmpty() .GroupBy(t => t.Site) .Select(g => new { Site = s.Site, Libelle = s.Libelle, NbreAppelSortant = g.Count(), NbreAppelSortantGsm = g.Count(t => t.Nature_Comm == "M"), NbreAppelSortantLocaux = g.Count(t => t.Nature_Comm == "L"), NbreAppelSortantNationnaux = g.Count(t => t.Nature_Comm == "N"), NbreAppelSortantInternationnaux = g.Count(t => t.Nature_Comm == "I"), })

---