I have a SQL Query which I want to convert to LINQ. I am using C#. I tried both LINQPad and Linqer. Linqer does not do a RIGHT OUTER JOIN
. LINQPad does not do any conversion at all.
Can it be done via nested joins or like?
SELECT dbo.tblPatientMaster.ptM_Name
FROM dbo.tblClinicalInformation
INNER JOIN dbo.tblPatientDiagnosis
INNER JOIN dbo.tblDiagnosisInformation ON
dbo.tblPatientDiagnosis.ptD_tgIId = dbo.tblDiagnosisInformation.tgI_Id
ON dbo.tblClinicalInformation.tcI_Id = dbo.tblDiagnosisInformation.tgI_tcIId
RIGHT OUTER JOIN dbo.tblPatientInformation ON
dbo.tblPatientDiagnosis.ptD_ptIId = dbo.tblPatientInformation.ptI_Id
LEFT OUTER JOIN dbo.tblDepartmentMaster
INNER JOIN dbo.tblDoctorMaster ON
dbo.tblDepartmentMaster.deptM_Id = dbo.tblDoctorMaster.dcM_deptMId
ON dbo.tblPatientInformation.ptI_dcMId = dbo.tblDoctorMaster.dcM_Id
RIGHT OUTER JOIN dbo.tblPatientMaster ON
dbo.tblPatientInformation.ptI_Id = dbo.tblPatientMaster.ptM_Id