LINQ Query not working for Right Outer Join

206 Views Asked by At

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
0

There are 0 best solutions below