c# - 我如何将我的 SQL 查询转换为不等于的 Linq?
问题描述
这是我的 sql 查询;
select * from kirala inner join saatler on Kirala.Tarih = '2020-05-31' and Kirala.Onay = 'true' and Kirala.SaatID != saatler.ID
我是转换这个;
var kirala2 = from t1 in _context.Kirala
join t2 in _context.Saatler on t1.SaatID equals t2.ID
where t1.Tarih == "2020-05-31" && t1.Onay == true && t1.YatID == id
select new Saatler { Saat = t2.Saat, ID = t2.ID };
但这对我不起作用,因为t1.SaatID equals t2.ID
我不能使用不等于我还能做什么?
解决方案
您可以将连接中的所有条件移动到 where
var kirala2 = from t1 in _context.Kirala
from t2 in _context.Saatler
where t1.SaatID != t2.ID
&& t1.Tarih == "2020-05-31"
&& t1.Onay == true
&& t1.YatID == id
select new Saatler { Saat = t2.Saat, ID = t2.ID };
推荐阅读
- java - tool to find transitive backward dependencies in java code
- .htaccess - I want a subdomain only accessible to some some specific computer in the local network
- ios - Framework Not supported in Simulator - Make Dummy Framework
- php - Wordpress:根据价格更改div的内容
- php - laravel 社交名媛 Facebook 登录
- c# - Call MySql stored procedure which take 2 parameters from asp.net core 2.2 web API controller
- javascript - If an element is nested below divs, when do we need to care about div classes when selecting?
- c - C standard library HTTP 301 Redirect using sockets on Objective-C
- php - TypeError:在未使用 $.post() 方法实现接口 FormData 错误的对象上调用了“附加”
- python - 如何使用具有相同范围的 2 个变量进行 for 循环?