我有一個SQL查詢，它選擇前5000個數據，并有一些條件?，F在我的問題是，如何從實體框架編寫相同的查詢？可能嗎？我想知道從實體框架實現此查詢的最有效方法。查詢：select TOP 5000 * from MyData where Type=1 and UPC not in (select UPC from MyData where Type=2 AND UPC IS NOT NULL)C# 實體：using (var ctx = new db_ProductionEntities()){ //var items = ctx.MyData.Take(10).ToList(); need to know how to write query here}
1 回答
揚帆大魚
TA貢獻1799條經驗 獲得超9個贊
var answer = (from d1 in ctx.MyData
where d1.Type == 1 and
!(from d2 in ctx.MyData
where d2.Type == 2 and d2.UPC != null
select d2.UPC
).Contains(d1.UPC)
order by d1.Id //or some other field, it's needed for "Take"
select d1).Take(5000).ToList();
- 1 回答
- 0 關注
- 126 瀏覽
添加回答
舉報
0/150
提交
取消