Entity Framework 5.0 增删改查(级联)



Entity Framework 5.0 增删改查(级联)

Entity Framework 5.0 增删改查(级联)
[TestClass]
    public class UnitTest1
    {
        [TestMethod]
        public void TestInsert()
        {
            using (TestEntities1 context = new TestEntities1())
            {
                User user = new User();
                user.ID = 10;
                user.UName = "Jim";

                user.Address = new Address();
                user.Address.ID = 7;
                user.Address.Address1 = "附件";
               
                context.Set<User>().Add(user);


                DbEntityEntry<Address> entry = context.Entry<Address>(user.Address);
                entry.State = System.Data.EntityState.Modified;
                //entry.State = System.Data.EntityState.Added;

                DbEntityEntry<User> entry2 = context.Entry<User>(user);
                entry2.State = System.Data.EntityState.Added;

                context.SaveChanges();
               
            }
        }

         [TestMethod]
        public void TestUpdate()
        {
            using (TestEntities1 context = new TestEntities1())
            {
                User user = new User();
                user.ID = 10;
                user.UName = "Jim";

                user.Address = new Address();
                user.Address.ID = 7;
                user.Address.Address1 = "福建";

                context.Set<User>().Add(user);


                DbEntityEntry<Address> entry = context.Entry<Address>(user.Address);
                entry.State = System.Data.EntityState.Modified;

                DbEntityEntry<User> entry2 = context.Entry<User>(user);
                entry2.State = System.Data.EntityState.Modified;

                context.SaveChanges();

            }
        }

         [TestMethod]
        public void TestSelect()
        {
            using (TestEntities1 context = new TestEntities1())
            {
                var user = context.UserAndSubs().Where(u => u.ID == 10)
                    .Select(u => u).ToList();
            }
        }

         [TestMethod]
        public void TestDelete()
        {
            using (TestEntities1 context = new TestEntities1())
            {
                var user = context.UserAndSubs().Where(u => u.ID == 10).First();

                context.Set<User>().Add(user);
                
                context.Set<Address>().Remove(user.Address);

                context.Entry<User>(user).State = System.Data.EntityState.Deleted;

                context.SaveChanges();
            }
        }
    }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值