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

gcc - MinGW's ld cannot perform PE operations on non PE output file -

timeout - Handshake_timeout on RabbitMQ using python and pika from remote vm -

c# - Search and Add Comment with OpenXML for Word -