EF增删改操作

 

class Program
    {
        static void Main(string[] args)
        {
            Program test = new Program();
            //test.AddTest();
            test.UpdateNameTest();
            //test.UpdateTest();
            //test.DeleteTest();

            Console.WriteLine("按任意键退出！");
            Console.ReadKey();
        }

        public Program()
        {
            this.DbContext = new TestdbEntities();
        }

        public TestdbEntities DbContext { get; set; }


        public void AddTest()
        {
            user u = new user();
            u.Name = "dian";
            u.Age = 20;
            u.Phone = 133;
            u.Address = "上海市";

            this.DbContext.user.Add(u);
            this.DbContext.SaveChanges();

            Console.WriteLine("数据添加成功！");
        }

        public void UpdateTest()
        {
            user u = new user();
            u.Id = 3;
            u.Name = "xing";
            u.Age = 18;
            u.Phone = 13370218081;
            u.Address = "上海市杨浦区";

            this.DbContext.Entry<user>(u).State = System.Data.EntityState.Modified;
            this.DbContext.SaveChanges();

            Console.WriteLine("数据修改成功！");
        }

        public void UpdateNameTest()
        {
            //user u = this.DbContext.user.Where(o => o.Id == 4).FirstOrDefault();
            //if (u != null)
            //    u.Name = "xxxx";

            user u = new user();
            u.Name = "attach";
            u.Age = 20;
            u.Phone = 133;
            u.Address = "上海市";
            u.Id = 6;

            this.DbContext.user.Attach(u);
            this.DbContext.Entry<user>(u).Property<string>(o => o.Name).IsModified = true;
            //this.DbContext.Entry<user>(u).Property("Name").IsModified = true;

            this.DbContext.SaveChanges();

            Console.WriteLine("数据Name修改成功！");
        }

        public void DeleteTest()
        {
            user u = new user();
            u.Id = 3;

            this.DbContext.Entry<user>(u).State = System.Data.EntityState.Deleted;
            this.DbContext.SaveChanges();

            Console.WriteLine("数据删除成功！");
        }
    }