Hi! any one can help me translate this SQL to LINQ to SQL?
Especially with the CASE WHEN statement.

DECLARE @Language INT
SET @Language = 1

SELECT
tblSites.ID,
tblSites.Code + ' ' + tblSites.NoCivic + ', ' + CASE WHEN @Language = 1 THEN DV.DescrFr ELSE DV.DescrEn END AS Street
FROM
tblSites
LEFT JOIN tblDomval AS DV ON tblSites.pProvinceID = DV.ID