i'm searching linq left outer join query syntax, , i'm struggling find answer that. specific sql query is:
select tblbpgood.barcode, tblbpgood.code, name, retailprice, goodgroupid, tblbpgoodgroupl.description, purchaseunittypeid, salesunittypeid, tblbpunittypel.description salesunittype, tblbpunittypel_1.description purchaseunittype tblbpgood left outer join tblbpgoodgroupl on tblbpgood.goodgroupid = tblbpgoodgroupl.id left outer join tblbpunittypel on tblbpgood.salesunittypeid = tblbpunittypel.id left outer join tblbpunittypel tblbpunittypel_1 on tblbpgood.purchaseunittypeid = tblbpunittypel_1.id
Comments
Post a Comment