BAQ in BPM Code Block

[CasterConcepts (Justin Powell)]

@hkeric.wci

var Rows = 
	(from jp in Db.JobProd 
		where jp.Company == Session.CompanyID 
			 && jp.VendorNum == 497
		select jp
	).ToList(); // You can also use .FirstOrDefault() if you only want 1 row

I envy your skills sir… I did use FirstOrDefault, as I only want the 1 line. Can’t believe it was that easy… I need to learn more about Linq…

Final results was literally:

var JobOper = 
  (from jo in Db.JobOper 
    where jo.Company == Session.CompanyID
       && jo.JobNum == Job
       && jo.SubContract == true
       && jo.VendorNum == 497
    select jo
  ).FirstOrDefault();
  
  Asm = JobOper.AssemblySeq;
  Opr = JobOper.OprSeq;