EF的SqlQuery和EntitySql

来源：互联网发布：车铣复合数控车床编程编辑：程序博客网时间：2024/06/10 22:27

using (var mc = new MenuContext())            {                var m =                    mc.Menus.SqlQuery(                        "select Id, Name, CreateTime, IsDelete,Note from menus where id=@id and IsDelete=@IsDelete",                        new object[] { new SqlParameter("@id", 1), new SqlParameter("@IsDelete", false) });                var mm = m.First();                Console.WriteLine(mm.Name + mm.IsDelete);                var mm2 = mc.Database.ExecuteSqlCommand("update menus set name=@name where id=@id",                    new object[] { new SqlParameter("@name", "jun"), new SqlParameter("@id", 1) });                Console.WriteLine(mm2);                var m2 = mc.Database.SqlQuery<int>("select id from menus where id=1").ToList();                Console.WriteLine(m2);             }

using (var mc = new MenuContext())            {                var munes =                    ((IObjectContextAdapter) mc).ObjectContext.CreateQuery<Menu>("select value c from menus as c");                foreach (var ms in munes)                {                     Console.WriteLine(ms.Name);                }            }

using (var conn=new MenuContext().Database.Connection)            {                var cmd = conn.CreateCommand();                conn.Open();                cmd.CommandText = "select name,note from menus";                using (var reader=cmd.ExecuteReader(CommandBehavior.SequentialAccess))                {                    while (reader.Read())                    {                        Console.WriteLine(reader.GetString(1));                    }                }            }

using (var mc = new MenuContext())            {                var sql = @"insert into menus(Name,CreateTime,IsDelete,Note)values(@Name,@CreateTime,@IsDelete,@Note)";                var parms = new object[]                {                    new SqlParameter("@Name", "coco"),                    new SqlParameter("@CreateTime", DateTime.Now),                    new SqlParameter("@IsDelete", false),                    new SqlParameter("@Note", "coco i love u")                };                var rowCount = mc.Database.ExecuteSqlCommand(sql, parms);                                 foreach (var item in mc.Menus)                {                    Console.WriteLine(item.Name);                }            }

0 0