业务场景
EF 查询符合条件的结果集
错误示例1
LINQ to Entities does not recognize the method get_Item(Int32)' method
主要错误原因
linq表达式中无法识别下标运算(EF查询Where不能包含下标运算的表达式)
关系数据库不能识别 含有下标运算的表达式树翻译成的sql查询
EFFristModelEntities db = new EFFristModelEntities();//数据库操作类,上下文类。
List<String> cleanStudentIDS=new List<String>{"10000000001","10000000002","10000000003"}
for (int i = 0; i < cleanStudentIDS.Count; i++)
{
//执行报错
var userInfoList = db.UserInfo.Where(u => u.StudentID==cleanStudentIDS[i]);
if(userInfoList= null&&userInfoList.count)
{
return "存在该学生信息不能删除!";
}
}
正确示例1
EFFristModelEntities db = new EFFristModelEntities();//数据库操作类,上下文类。
List<String> cleanStudentIDS=new List<String>{"10000000001","10000000002","10000000003"}
for (int i = 0; i < cleanStudentIDS.Count; i++)
{
//
var cleanStudentID=cleanStudentIDS[i];
var userInfoList = db.UserInfo.Where(u => u.StudentID==cleanStudentID);
if(userInfoList= null&&userInfoList.count)
{
return "存在该学生信息不能删除!";
}
}
正确示例2
EFFristModelEntities db = new EFFristModelEntities();//数据库操作类,上下文类。
List<String> cleanStudentIDS=new List<String>{"10000000001","10000000002","10000000003"}
for (int i = 0; i < cleanStudentIDS.Count; i++)
{
//ToList() 或者ToArray() 将数据缓存到本地再进行操作
var userInfoList = db.UserInfo.ToList().Where(u => u.StudentID==cleanStudentIDS[i].ID);
if(userInfoList= null&&userInfoList.count)
{
return "存在该学生信息不能删除!";
}
}