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

Code SQL : Sélectionner tout - Visualiser dans une fenêtre à part
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