This question is locked. New answers and comments are not allowed.
I would like to map this oracle sql query to LINQ for my silverlight application:
SELECT DISTINCT (DOS.NODOSSIER) AS DOSSIER,
DOS.CTE AS CTE,
DOS.SIGCOR AS MED,
TRIM(MAL.NOM) AS NOM,
TRIM(MAL.NOMJF) AS NOMJF,
TRIM(TRIM(MAL.PRENOM) || ' ' || TRIM(MAL.PRENOM2)) AS PRENOM,
MAL.SEXE AS SEXE,
MAL.DATNAI AS DATENAI,
TRUNC((MONTHS_BETWEEN(SYSDATE, TO_DATE(MAL.DATNAI, 'yyyymmdd'))) / 12) AS AGE,
DOS.PASSDOS AS PASSDOS,
MAL.DATDC AS DATEDC,
GL.UNITE AS UNITE,
GL.NUMETAGE AS ETAGE,
GL.NUMCHAMBRE AS CHAMBRE,
GL.PLACELIT AS LIT,
GL.NUMTEL AS TEL,
TO_CHAR(DATEDEB_MOUV, 'dd/mm/yyyy hh24:mm') AS DEBMOUV,
TO_CHAR(DATEFIN_MOUV, 'dd/mm/yyyy hh24:mm') AS FINMOUV,
TO_CHAR(SYSDATE, 'dd/mm/yyyy hh24:mm') AS DATESYS
FROM IM_MALAD MAL, IM_DOSSIER DOS
LEFT JOIN GLOM_VIEW_SEJOUR GL ON GL.NODOSSIER = DOS.NODOSSIER AND (GL.FLAG_MOUV IS NULL OR GL.FLAG_MOUV = ' ')
AND (GL.FLAGPROVIS_MOUV != 'P' OR GL.FLAGPROVIS_MOUV IS NULL)
AND (GL.FLAG_OCC IS NULL OR GL.FLAG_OCC = ' ')
AND (GL.FLAGPROVIS_OCC != 'P' OR GL.FLAGPROVIS_OCC IS NULL)
WHERE MAL.NODOSSIER = DOS.NODOSSIER AND MAL.NOM LIKE 'BERNIER%' AND MAL.SEXE = 'M'
ORDER BY NOM, PRENOM, DOS.NODOSSIER
SELECT DISTINCT (DOS.NODOSSIER) AS DOSSIER,
DOS.CTE AS CTE,
DOS.SIGCOR AS MED,
TRIM(MAL.NOM) AS NOM,
TRIM(MAL.NOMJF) AS NOMJF,
TRIM(TRIM(MAL.PRENOM) || ' ' || TRIM(MAL.PRENOM2)) AS PRENOM,
MAL.SEXE AS SEXE,
MAL.DATNAI AS DATENAI,
TRUNC((MONTHS_BETWEEN(SYSDATE, TO_DATE(MAL.DATNAI, 'yyyymmdd'))) / 12) AS AGE,
DOS.PASSDOS AS PASSDOS,
MAL.DATDC AS DATEDC,
GL.UNITE AS UNITE,
GL.NUMETAGE AS ETAGE,
GL.NUMCHAMBRE AS CHAMBRE,
GL.PLACELIT AS LIT,
GL.NUMTEL AS TEL,
TO_CHAR(DATEDEB_MOUV, 'dd/mm/yyyy hh24:mm') AS DEBMOUV,
TO_CHAR(DATEFIN_MOUV, 'dd/mm/yyyy hh24:mm') AS FINMOUV,
TO_CHAR(SYSDATE, 'dd/mm/yyyy hh24:mm') AS DATESYS
FROM IM_MALAD MAL, IM_DOSSIER DOS
LEFT JOIN GLOM_VIEW_SEJOUR GL ON GL.NODOSSIER = DOS.NODOSSIER AND (GL.FLAG_MOUV IS NULL OR GL.FLAG_MOUV = ' ')
AND (GL.FLAGPROVIS_MOUV != 'P' OR GL.FLAGPROVIS_MOUV IS NULL)
AND (GL.FLAG_OCC IS NULL OR GL.FLAG_OCC = ' ')
AND (GL.FLAGPROVIS_OCC != 'P' OR GL.FLAGPROVIS_OCC IS NULL)
WHERE MAL.NODOSSIER = DOS.NODOSSIER AND MAL.NOM LIKE 'BERNIER%' AND MAL.SEXE = 'M'
ORDER BY NOM, PRENOM, DOS.NODOSSIER