c# - entity spaces innerjoin syntax -
i have following code attempting complete query fill datalist. need join them can't find entity spaces documentation follows syntax style using, attempting change/rewrite little of code possible. please me complete query.
let table estimtes contacts field id contractors contains , want join on it, have far:
estimates resest = new estimates(); contractors cons = new contractors(); cons.query.loaddatatable(); datalist dl = (datalist)pn90day.findcontrol("dlpreapprovalestimates"); resest.query.where(resest.query.fddkey.equal(fddkey)); resest.query.innerjoin(
estimatesquery eq = new estimatesquery("es"); contractorsquery cq = new contractorsquery("co"); eq.where(eq.fddkey == fddkey); eq.innerjoin(cq).on(eq.contractorky == cq.contractorky); estimatescollection coll = new estimatescollection(); if(coll.load(eq)) { // have found @ least 1 }
i author of entityspaces
Comments
Post a Comment