Hi think I have found;
Code:
var lSite = from dta in gmr.tblSites
join dv in gmr.tblDomVals on dta.pProvinceID equals dv.ID into dvprov
from dvProv in dvprov.DefaultIfEmpty()
where dta.EstDepot == (pSiteType == Enums.Enums.eTypeSite.Depot) && dta.Actif == true
select new
{
dta.ID,
Valeur = dta.Code ?? string.Empty
+ " " + dta.NoCivic ?? string.Empty
+ ", " + dta.Rue ?? string.Empty
+ " " + (GMR.Language.Translate.CurrentLanguage == Enums.Enums.eLanguage.Francais ? dvProv.DescrFr
: GMR.Language.Translate.CurrentLanguage == Enums.Enums.eLanguage.Anglais ? dvProv.DescrEn
: dvProv.DescrFr)
+ " " + dta.CodePostal ?? string.Empty
};