/// <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);
}
