Help me to Convert sql to linq

Check out LinqPad[^]. This great and free tool lets you work directly with your database using LINQ, SQL, ESQL and see the equivalent SQL for your LINQ or Lambda expressions.

Select Distinct A.SANCTION_ORDER_NO,A.SANCTION_ORDER_DATE,
D.FORCE_NO
From FM_TB_HOSTEL_SUBSIDY_SANCTION_HDR_T A join
FM_TB_HOSTEL_SUBSIDY_SANCTION_APPDTL_T B on A.SANCTION_ORDER_NO =B.SANCTION_ORDER_NO
join FM_TB_HOSTEL_SUBSIDY_SANCTION_DTL_T C on C.EMP_SEQ_NO =B.EMP_SEQ_NO And C.SANCTION_ORDER_NO =B.SANCTION_ORDER_NO
Join PM_TB_APP_APPOINTMENT_T D On D.EMP_SEQ_NO =B.EMP_SEQ_NO
Join PM_TB_MST_RANK_M E On D.PRESENT_RANK_CODE =E.RANK_CODE

Select Distinct A.SANCTION_ORDER_NO,A.SANCTION_ORDER_DATE,
D.FORCE_NO
From FM_TB_HOSTEL_SUBSIDY_SANCTION_HDR_T A join
FM_TB_HOSTEL_SUBSIDY_SANCTION_APPDTL_T B on A.SANCTION_ORDER_NO =B.SANCTION_ORDER_NO
join FM_TB_HOSTEL_SUBSIDY_SANCTION_DTL_T C on C.EMP_SEQ_NO =B.EMP_SEQ_NO And C.SANCTION_ORDER_NO =B.SANCTION_ORDER_NO
Join PM_TB_APP_APPOINTMENT_T D On D.EMP_SEQ_NO =B.EMP_SEQ_NO
Join PM_TB_MST_RANK_M E On D.PRESENT_RANK_CODE =E.RANK_CODE

select C.OrganizationID from aspnetdb.dbo.aspnet_Users A INNER JOIN aspnetdb.dbo.aspnet_Profile B
on A.UserId = B.UserId INNER JOIN sos.dbo.OrganizationInformation C ON
substring(B.PropertyValuesString,1,datalength(B.PropertyValuesString)) = C.OrganizationID
where A.UserName = @UserName and B.PropertyNames like 'MartSOSOrgId%'

var query = from p in dc1.aspnet_Users
join p1 in dc1.aspnet_Profiles on p.UserId equals p1.UserId
join p2 in dc.OrganizationInformations on
p1.PropertyValuesString.Substring(1,p1.PropertyValuesString.Length) equals p2.organizationID
where (p.UserName == userName) && (p1.PropertyNames.Contains("MartSOSOrgId"))

select C.OrganizationID from aspnetdb.dbo.aspnet_Users A INNER JOIN aspnetdb.dbo.aspnet_Profile B
on A.UserId = B.UserId INNER JOIN sos.dbo.OrganizationInformation C ON
substring(B.PropertyValuesString,1,datalength(B.PropertyValuesString)) = C.OrganizationID