/// <summary> /// 删除 /// </summary> /// <param name="sample"></param> /// <returns></returns> public bool Delete(EFSample sample) { using (IDbContext dbcontext = _contextFactory.Create()) { return(dbcontext.Delete(sample)); } }
/// <summary> /// 创建 /// </summary> /// <param name="samle">EFSample</param> /// <returns></returns> public bool Create(EFSample samle) { using (IDbContext dbcontext = _contextFactory.Create()) { return(dbcontext.Create <EFSample>(samle)); } }
public void ExecuteNonQueryTest() { string sql = @"INSERT INTO [dbo].[EFSample] ([ID] ,[CreateTime] ,[ModifyTime] ,[Available] ,[UserName]) VALUES (@ID ,@CreateTime ,@ModifyTime ,@Available ,@UserName)"; EFSample sample = new EFSample { Available = true, CreateTime = DateTime.Now, ID = Guid.NewGuid(), ModifyTime = DateTime.Now, UserName = "******" }; int actual = dataManager.ExecuteNonQuery <EFSample>(sql, sample); Assert.IsTrue(actual > 0); }
public void UpdateTest() { EFSample sample = new EFSample { Id = _testID, ModifyTime = DateTime.Now, UserName = "******" }; bool actual = _sampleService.Update(sample); Assert.IsNotNull(actual); }
public void TransactionFailTest() { EFSample sample3 = new EFSample { UserName = "******" }; EFSample sample4 = new EFSample { UserName = null }; bool actual = _sampleService.CreateWithTransaction(sample3, sample4); Assert.IsFalse(actual); }
public void TransactionSuccessTest() { EFSample sample = new EFSample { UserName = "******" }; EFSample sample2 = new EFSample { UserName = "******" }; bool actual = _sampleService.CreateWithTransaction(sample, sample2); Assert.IsTrue(actual); }
/// <summary> /// 事务 /// </summary> /// <param name="sample">The sample.</param> /// <param name="sample2">The sample2.</param> /// <returns></returns> public bool CreateWithTransaction(EFSample sample, EFSample sample2) { bool result = true; using (IDbContext dbcontext = _contextFactory.Create()) { try { dbcontext.BeginTransaction();//开启事务 dbcontext.Create(sample); dbcontext.Create(sample2); dbcontext.Commit(); } catch (Exception) { dbcontext.Rollback(); result = false; } } return(result); }
public void GetByKeyIdTest() { EFSample actual = _sampleService.GetByKeyID(_testID); Assert.IsNotNull(actual); }
public void GetFirstOrDefaultTest() { EFSample actual = _sampleService.GetFirstOrDefault(ent => ent.Id == _testID); Assert.IsNotNull(actual); }