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)[email protected] and status=1 and [email protected]", new SqlParameter("@time", DateTime.Now.ToString("yyyy-MM-dd")), new SqlParameter("@uid", uid)).FirstOrDefault();

 

asp.net EF架構執行原生SQL語句