无法添加具有已在使用中的键的实体错误

问题描述

嗨

我将Northwind数据库用于linq查询.从datagrid收到的记录
并将其用于在Customer和Order表中插入记录.但是会发生此异常无法使用已使用的键添加实体，并且出现错误"

hi

i use Northwind data base for linq query. received record from datagrid
and using it to inserting record in Customer and Order tables.but ocure this exception "Cannot add an entity with a key that is already in use Error"

var Nwind_dc = new DataClasses1DataContext();
          
            foreach (var Cust in GridTable)
            {
                var customer = new Customer
                {
                    CustomerID = Cust.CustomerID,
                    CompanyName = Cust.CompanyName,
                    ContactTitle = Cust.ContactTitle


                };

                var order = new Order { OrderDate = Cust.OrderDate, EmployeeID = Cust.EmployeeID };
               
                customer.Orders.Add(order);
                Nwind_dc.Customers.InsertOnSubmit(customer);
                
             
            }
            Nwind_dc.SubmitChanges();

推荐答案

这篇关于无法添加具有已在使用中的键的实体错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！