sql server 2008 - How to use OR in join while using Entity Framework -


can 1 convert following sql statement entity framework c# or vb.net me?

sql statement:

 select t1.*, t2.*   tblwistransacs t1  inner join tblwcbtransacs t2 on t1.ticketno = t2.ticketno                                   or t1.ticketno = t2.customernumber 

var result = (from t1 in dbcontext.tblwistransacs               join t2 in dbcontext.tblwcbtransacs on 1 equals 1               (t1.ticketno == t2.ticketno || t1.ticketno == t2.customernumber)               select new { t1, t2 }).tolist(); 

enter image description here


Comments

Popular posts from this blog

symfony - TEST environment only: The database schema is not in sync with the current mapping file -

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -