c# ef事件

 using (var tran = db.Database.BeginTransaction())
            {
                try
                {
                    foreach (var product in seriesProducts)
                    {
                        #region 添加到店铺商品
                        bool bIsStoreExist = (from p in lstStoreProduct
                                              where p.SpID == product.SpID
                                              select p).ToList().Count() > 0;
                        if (!bIsStoreExist)
                        {
                            var pStoreProduct = new TbStoreProduct
                            {
                                SpID = product.SpID,
                                IdStore = idStore,
                                IdShangHu = idShangHu,
                                //DateUnsalableEs = default,
                                IsDiscord = false, //是否促销
                                IsNotSale = false //是否销售
                            };
                            db.TbStoreProduct.Add(pStoreProduct);
                        }
                        #endregion
                        #region 添加商户商品
                        bool bIsShangHuExist = (from p in lstShangHuProduct
                                                where p.SpID == product.SpID
                                                select p).ToList().Count() > 0;
                        if (!bIsShangHuExist)
                        {
                            var pShangHuProduct = new TbShangHuProduct
                            {
                                SpID = product.SpID,
                                IdShangHu = idShangHu,
                                FlagBuFenHuo = false,
                                IsForbiddenBuy = false
                            };
                            db.TbShangHuProduct.Add(pShangHuProduct);
                        }
                        #endregion
                    }
                    db.SaveChanges();
                    tran.Commit();
                }
                catch (Exception)
                {
                    tran.Rollback();
                    nRet = -3;
                }
            }
            return nRet;
        }