SQL语句中多个ID来查询获取数据的方法
select id,name from User where id in (1,2,3);
LINQ中对应的语句是
int[] idArr=[1,2,3];
var list=_db.User.Where(x=>idArr.contains(x.id)).toList();
NOT IN对应的语句是
var list=_db.Users.Where(x=>!idArr.contains(x.id)).toList();
SQL语句中多个ID来查询获取数据的方法
select id,name from User where id in (1,2,3);
LINQ中对应的语句是
int[] idArr=[1,2,3];
var list=_db.User.Where(x=>idArr.contains(x.id)).toList();
NOT IN对应的语句是
var list=_db.Users.Where(x=>!idArr.contains(x.id)).toList();