EF 中db.Database.SqlQuery＜T＞的用法

第一种：

 public ActionResult Index()
        {
            using (MyContext db=new MyContext())
            {
                Classes c = new Classes();
                string sql = string.Format("select * from Class where Id={0}",1);
                IList<Classes> qur=db.Database.SqlQuery<Classes>(sql).ToList();

                var a = qur.Count;
            }
                return View();
        }





第二种 调用存储过程：
public string YanJiuShengPeiYangZhuTiList()
        {
            var account = DataCollection.userinfo.UserAccount;
            SqlParameter[] para = new SqlParameter[] { new SqlParameter("@account", account) };

            var result = ""; 
           var mode = Model.Database.SqlQuery<Zsl>("exec usp_Total3 @account", para).OrderByDescending(a=>a.NJ);
          
            result = mode.ToJson();
            return result;
        }



操作语句用：
db.Database.ExecuteSqlCommand(sql)

列如
 public ActionResult Index2()
        {
            using (MyContext db=new MyContext())
            {
                Classes c = new Classes();
                string sql = string.Format("UPDATE Class set ClassName='十班' where Id={0} ",7);
                int a= db.Database.ExecuteSqlCommand(sql);
            }
                return View();
        }