任何人都可以为我将以下SQL语句转换为Entity Framework C#或VB.net吗?
SQL语句:
select t1.*, t2.*
from 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
where (t1.TicketNo == t2.TicketNo || t1.TicketNo == t2.customernumber)
select new { t1, t2 }).ToList();
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句