首页 > 解决方案 > 字典问题(数据库中的自动完成字段)

问题描述

我有以下代码在其中创建客户。接下来,在字典的帮助下,对于每个输入的电子邮件,我想创建我的 Id_Cus

public void InsertCustomer(customer customerDataContract)
        {
            //MySQLEntities Cust = new MySQLEntities();
            customer cust = new customer();
            {
                //cust.Id_Cus = Convert.ToInt32(customerDataContract.Id_Cus);
                cust.FirstName_Cus = customerDataContract.FirstName_Cus;
                cust.LastName_Cus = customerDataContract.LastName_Cus;
                cust.PhoneNum_Cus = Convert.ToInt32(customerDataContract.PhoneNum_Cus);
                cust.Email_Cus = customerDataContract.Email_Cus;
                //}
                Dictionary<string, int> dict = dc.customers.GroupBy(x => x.Email_Cus, y => y.Id_Cus)
                                                                 .ToDictionary(x => x.Key, y => y.FirstOrDefault());

                dc.customers.Add(cust);
                dc.SaveChanges();
                int k = Convert.ToInt32(cust.Id_Cus);
                customer custFromDb = (from n in dc.customers
                                       where n.Id_Cus == k
                                       select n).Include(c => c.customerpreference).Include(c=>c.orders).Include(c=>c.dishesrankings).First();
            }

        }

我尝试以这种方式开始记录,但是,在使用 Id_Cus=0 记录第一个客户后,抛出异常“MySqlException:重复条目 '0' for key 'customer.PRIMARY'”

可能是什么问题呢?

在此处输入图像描述

标签: c#mysqlsqlentity-frameworkdictionary

解决方案


推荐阅读