记一次entityFreamWork savechange失效及解决方案

private void ExcelIn_Click(object sender, EventArgs e)
        {
           //站点信息
            var stationsInfo = ec_DataContext.StationMessage.Where(x => x.Sort > 500).ToList();
            //级联查询确定开票信息与sort
            var this_Order = ec_DataContext.KaiPiaoUserInfo.Join(ec_DataContext.PipeUserInfo, m => m.HotId, f => f.HotId, (m, f) => new {
                m.PrintId,
                m.PipeUserName,
                f.Sort,
                f.HotId,
                f.Net
            }).Where(x=>x.Net==2).ToList();
            //开票信息
            var kaipiaousersInfo = ec_DataContext.KaiPiaoUserInfo.Where(x => x.Net == 2).ToList();
            string ThisStation = "";
            string This_PrintId = "";
            OpenFileDialog dialog = new OpenFileDialog();
            dialog.Multiselect = true;//该值确定是否可以选择多个文件
            dialog.Title = "请选择文件夹";
            dialog.Filter = "表格文件(*.xls)|*.xls";

            if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                string file = dialog.FileName;
                string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + file + ";" + "Extended Properties=Excel 8.0;";//Excel 8.0;HDR=no;IMEX=1

                using (var conn = new OleDbConnection(strConn))
                {
                    conn.Open();
                    System.Data.DataTable sheetsName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "Table" }); //得到所有sheet的名字
                    string firstSheetName = sheetsName.Rows[0][2].ToString(); //得到第一个sheet的名字
                    string sql = string.Format("SELECT * FROM [{0}]", firstSheetName); //查询字符串
                                                                                       //string sql = string.Format("SELECT * FROM [{0}] WHERE [日期] is not null", firstSheetName); //查询字符串

                    OleDbDataAdapter ada = new OleDbDataAdapter(sql, strConn);
                    DataSet set = new DataSet();
                    ada.Fill(set);
                    int sort = 0;
                    string This_HotId = "";
                    for (int i = 0; i < set.Tables[0].Rows.Count; i++)
                    {
                        try
                        {
                            //改站点信息的顺序
                            ThisStation = set.Tables[0].Rows[i][1].ToString();
                            This_PrintId = set.Tables[0].Rows[i][2].ToString().Trim();
                            sort = stationsInfo.Where(x => x.StationCh.Trim() == set.Tables[0].Rows[i][1].ToString().Trim()).FirstOrDefault().Sort;
                            stationsInfo.Where(x => x.StationCh.Trim() == set.Tables[0].Rows[i][1].ToString().Trim()).FirstOrDefault().PrintId = set.Tables[0].Rows[i][2].ToString().Trim();
                            
                            //改开票信息里的打印顺序
                            This_HotId =this_Order.Where(x => x.Sort == sort).FirstOrDefault().HotId;
                            
                            kaipiaousersInfo.Where(x => x.HotId == This_HotId).ToList().ForEach(x=>x.PrintId= set.Tables[0].Rows[i][2].ToString().Trim());
                        }
                        catch (NullReferenceException)
                        {
                            Console.WriteLine(ThisStation);
                            MessageBox.Show(ThisStation);
                            continue;
                        }
                    }
                    ec_DataContext.SaveChanges();
                }
            }
            MessageBox.Show("完成");
        }

就是把excel里的printid赋值给数据库的printid字段,然而savechange竟然不起作用???而且stationinfo是更改成功的,但是kaipianuserinfo就不行,完全不能理解为什么,下断点发现内存里已经修改了,只是没有savechange成功.

在网上搜了有说不在同一事务上下文未绑定,emmm我这肯定不是这个问题.Pass.

???没有别的原因了.,搜了几篇都是这个原因,不行,肯定是哪里不对.仔细检查了逻辑确定没问题之后,

我裂开了,一杯茶,一包烟,一个bug改一天.

总之,突发奇想是不是我没配置主键?,抱着试一试也死不了人的心情,我给ID字段加上了主键,

    public partial class KaiPiaoUserInfo
    {
        [Key]
        public int Id { get; set; }
        public string PrintId { get; set; }
        public string PiaoName { get; set; }
        public string HotId { get; set; }
        public int Type { get; set; }
        public double? BiLv { get; set; }
        public string PipeUserName { get; set; }
        public int? DongXia { get; set; }
        public int? Net { get; set; }
        public string XingZhi { get; set; }
        public string PiaoId { get; set; }
        public int? PrimeId { get; set; }
    }

就是这个Key!!.然后运行.查看结果????成功了?虽然不是很懂,但确实成功了.

不看文档就是这个下场!!!