//private static swerpEntities _dbContext = new swerpEntities("data source=.;initial catalog=swerp;user id=swerp;password=swerp2008"); //private DbContextTransaction transaction = _dbContext.Database.BeginTransaction(System.Data.IsolationLevel.RepeatableRead); public TestUpdateTransaction() { using (swerpEntities _dbContext = new swerpEntities("data source=.;initial catalog=swerp;user id=swerp;password=swerp2008")) { var itemType = _dbContext.Set <ItemType>().FirstOrDefault(p => p.CODE.Equals("110103")); itemType.DESCR = "测试"; _dbContext.SaveChanges(); } }
private void test() { using (swerpEntities _dbContext = new swerpEntities("data source=.;initial catalog=swerp;user id=swerp;password=swerp2008")) { var itemType = _dbContext.Set <ItemType>().FirstOrDefault(p => p.CODE.Equals("110103")); WriteLine("修改前次类编号【{0}】,名称【{1}】", itemType.CODE, itemType.DESCR); } Task.Factory.StartNew(() => { using (swerpEntities _dbContext = new swerpEntities("data source=.;initial catalog=swerp;user id=swerp;password=swerp2008")) { Thread.Sleep(50); var transaction = _dbContext.Database.BeginTransaction(System.Data.IsolationLevel.Serializable); var itemType1 = _dbContext.Set <ItemType>().FirstOrDefault(p => p.CODE.Equals("110103")); Thread.Sleep(200); WriteLine("第一次修改 获取到数据次类编号【{0}】,名称【{1}】", itemType1.CODE, itemType1.DESCR); itemType1.DESCR += "第一次修改"; WriteLine("第一次修改 次类编号【{0}】,名称【{1}】", itemType1.CODE, itemType1.DESCR); _dbContext.SaveChanges(); transaction.Commit(); } }); Task.Factory.StartNew(() => { using (swerpEntities _dbContext = new swerpEntities("data source=.;initial catalog=swerp;user id=swerp;password=swerp2008")) { Thread.Sleep(100); var transaction = _dbContext.Database.BeginTransaction(System.Data.IsolationLevel.Serializable); var itemType2 = _dbContext.Set <ItemType>().FirstOrDefault(p => p.CODE.Equals("110103")); WriteLine("第二次修改 获取到数据次类编号【{0}】,名称【{1}】", itemType2.CODE, itemType2.DESCR); itemType2.DESCR += "第二次修改"; WriteLine("第二次修改 次类编号【{0}】,名称【{1}】", itemType2.CODE, itemType2.DESCR); _dbContext.SaveChanges(); //_dbContext.Set<ItemType>(). transaction.Commit(); } }); Thread.Sleep(500); using (swerpEntities _dbContext = new swerpEntities("data source=.;initial catalog=swerp;user id=swerp;password=swerp2008")) { var itemType = _dbContext.Set <ItemType>().FirstOrDefault(p => p.CODE.Equals("110103")); WriteLine("修改后次类编号【{0}】,名称【{1}】", itemType.CODE, itemType.DESCR); } }
public ItemTypeRepositoryTest() { _dbContext = new swerpEntities("data source=.;initial catalog=swerp;user id=swerp;password=swerp2008"); _repository = new ItemTypeRepository(_dbContext); }