EF-调用sql进行操作

一丶执行

 class Program
    {
        static void Main(string[] args)
        {
            var db = new TestDBEntities();
            string sql = @"select * from UserInfor where id =@id";
            SqlParameter[] parameter = { 
                                       new SqlParameter("@id","0011"),

                                       };
            var userLit = db.Database.SqlQuery<UserInfor>(sql, parameter).ToList();

            foreach (var item in userLit)
            {
                Console.WriteLine("userName:" + item.userName);
            }
        }
    }

 二丶增删改使用(

ExecuteSqlCommand

)

转载于:https://www.cnblogs.com/chenze-Index/p/9377166.html