asp.net EF框架执行原生SQL语句

1.执行无参数sql：

string sql = "select * from IntegralInfo where convert(nvarchar,getdate(),23)='{0}' and status=1 and userinfoid='{1}'"; sql = string.Format(sql, DateTime.Now.ToString("yyyy-MM-dd"), uid); var IntegralInfoObj = db.Database.SqlQuery<IntegralInfo>(sql).FirstOrDefault();

2.执行有参数sql：

var IntegralInfoObj = db.Database.SqlQuery<IntegralInfo>("select * from IntegralInfo where convert(nvarchar,getdate(),23)=@time and status=1 and userinfoid=@uid", new SqlParameter("@time", DateTime.Now.ToString("yyyy-MM-dd")), new SqlParameter("@uid", uid)).FirstOrDefault();

 

转载于:https://www.cnblogs.com/zoro-zero/p/4527558.html

相关资源：EF框架和sql语句的增删改查程序（winform），含sql脚本