8,497
社区成员
发帖
与我相关
我的任务
分享
var db = new ExamdaDbContext(EnmDb.ExamSystem_Set);
IQueryable<ExpressionClassModel> cities = db.ExpresstionClass;
ParameterExpression param = Expression.Parameter(typeof(ExpressionClassModel), "c");
Expression left = Expression.Property(param, typeof(ExpressionClassModel).GetProperty("Name"));
Expression right = Expression.Constant("心情");
Expression filter = Expression.Equal(left, right);
var result = db.ExpresstionClass.Where(Expression.Lambda<Func<ExpressionClassModel, bool>>(filter, param));
var query = from x in MyDbContext()
select x;
if(name !=null)
query = from x in query
where x.Name == name
select x;
你跟踪一下关系数据库执行的sql语句是什么?