EF 保存数据时,如果数据存在外键,则保存出错解决

下面时错误情况

如果外键对象  主键自增的话,那么EF会自动修改主键,然后自增存入DB,不会报错

如果主键改为不自增的话,那么保存的时候就会报错

var greadInfo = new GreadInfo() { id = 5, number = "04", createTime = new DateTime(1878, 8, 4), master = "asdfwer" };
using (CodeFirstDBContext dbContext = new CodeFirstDBContext())
            {
                
          
                try
                {
                    
                        var s = new Student()
                        {
                            name = "hjery",
                            number = "6795",
                            age = 56,
                            birthday = new DateTime(1854, 2, 5),
                            GreadInfo = greadInfo
                        };
                    var s2 = new Student()
                    {
                        name = "uyhjkfgjh",
                        number = "7689",
                        age = 43,
                        birthday = new DateTime(1896, 12, 25),
                        GreadInfo = greadInfo
                    };
                    List<Student> list = new List<Student>();
                    list.Add(s);
                    list.Add(s2);
                    // 写数据库
                    dbContext.Student.AddRange(list);
                    var i = dbContext.SaveChanges();
                    Console.WriteLine(i);
                }
                catch (DbEntityValidationException dbEx)
                {
                    Console.WriteLine(dbEx);
                }
                
            }

 

正确的情况    外键使用上下文对象

 using (CodeFirstDBContext dbContext = new CodeFirstDBContext())
            {
                
          
                try
                {
                    var greadInfo = dbContext.GreadInfo.Find(5);//根据主键查询,如果主键是多个,那么就写多个参数,按照主键顺序

                        var s = new Student()
                        {
                            name = "hjery",
                            number = "6795",
                            age = 56,
                            birthday = new DateTime(1854, 2, 5),
                            GreadInfo = greadInfo
                        };
                    var s2 = new Student()
                    {
                        name = "uyhjkfgjh",
                        number = "7689",
                        age = 43,
                        birthday = new DateTime(1896, 12, 25),
                        GreadInfo = greadInfo
                    };
                    List<Student> list = new List<Student>();
                    list.Add(s);
                    list.Add(s2);
                    // 写数据库
                    dbContext.Student.AddRange(list);
                    var i = dbContext.SaveChanges();
                    Console.WriteLine(i);
                }
                catch (DbEntityValidationException dbEx)
                {
                    Console.WriteLine(dbEx);
                }
                
            }

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值