public void SetParameterValuesGeneric() {
var category = new Category {
CategoryName = "Test",
Description = "FluentUtil"
};
// delete exist category
NorthwindAdoRepository.ExecuteNonQueryBySqlString(
@"DELETE FROM Categories where CategoryName = @CategoryName",
new AdoParameter("CategoryName", category.CategoryName, DbType.String, 255));
// insert
using(var command = NorthwindAdoRepository.GetProcedureCommand("SaveOrUpdateCategory", true)) {
AdoTool.SetParameterValues(NorthwindAdoRepository.Db,
command,
category,
command.Mapping(NameMappingUtil.CapitalizeMappingFunc('_', ' ')));
category.CategoryId = NorthwindAdoRepository.ExecuteCommand(command).AsInt(-1);
Assert.AreNotEqual(-1, category.CategoryId);
}
// update
using(var command = NorthwindAdoRepository.GetProcedureCommand("SaveOrUpdateCategory", true)) {
AdoTool.SetParameterValues(NorthwindAdoRepository.Db,
command,
category,
command.Mapping(NameMappingUtil.CapitalizeMappingFunc('_', ' ')));
category.CategoryId = NorthwindAdoRepository.ExecuteCommand(command).AsInt(-1);
Assert.AreNotEqual(-1, category.CategoryId);
}
}
public void FluentByNameMapper_Save() {
INameMapper nameMapper = new CapitalizeNameMapper();
var category = new Category
{
CategoryName = "Test",
Description = "FluentUtil"
};
// delete exist category
SQLiteRepository.ExecuteNonQueryBySqlString("DELETE FROM Categories where CategoryName = @CategoryName",
new AdoParameter("CategoryName", category.CategoryName, DbType.String, 255));
// insert
var result = SQLiteRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
category.CategoryId = result.AsInt(-1); //ConvertTool.DefValue(result, -1);
Assert.AreNotEqual(-1, category.CategoryId);
// update
result = SQLiteRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
Assert.AreNotEqual(0, result.AsInt());
}
public void PersistentObjectToDatabase() {
var category = new Category { CategoryName = "Test", Description = "FluentUtil" };
// delete exist category
SQLiteRepository.ExecuteNonQueryBySqlString("DELETE FROM Categories where CategoryName = @CategoryName",
new AdoParameter("CategoryName", category.CategoryName, DbType.String, 255));
// insert
var result = SQLiteRepository.ExecuteEntity("SaveOrUpdateCategory", category, CapitalizeMapper);
category.CategoryId = result.AsInt(-1);
Assert.AreNotEqual(-1, category.CategoryId);
// update
result = SQLiteRepository.ExecuteEntity("SaveOrUpdateCategory", category, CapitalizeMapper);
Assert.AreNotEqual(0, result.AsInt());
}
public void FluentByNameMapper_Save() {
INameMapper nameMapper = new CapitalizeNameMapper();
var category = new Category
{
CategoryName = "Test",
Description = "FluentUtil"
};
// delete exist category
NorthwindAdoRepository.ExecuteNonQueryBySqlString("DELETE FROM Categories where CategoryName = @CategoryName",
new AdoParameter("CategoryName", category.CategoryName));
// insert
var result = NorthwindAdoRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
category.CategoryId = result.AsInt(-1);
Assert.AreNotEqual(-1, category.CategoryId);
// update
result = NorthwindAdoRepository.ExecuteEntity("SaveOrUpdateCategory", category, nameMapper);
Assert.IsTrue(result.AsInt() > 0);
}
public void PersistentObjectToDatabase() {
try {
var category = new Category { CategoryName = "Test", Description = "FluentUtil" };
// delete exist category
NorthwindAdoRepository.ExecuteNonQueryBySqlString("DELETE FROM Categories where CategoryName = @CategoryName",
new AdoParameter("CategoryName", category.CategoryName));
// insert
var result = NorthwindAdoRepository.ExecuteEntity("SaveOrUpdateCategory", category, CapitalizeMapper);
category.CategoryId = result.AsInt(-1);
Assert.AreNotEqual(-1, category.CategoryId);
// update
result = NorthwindAdoRepository.ExecuteEntity("SaveOrUpdateCategory", category, CapitalizeMapper);
Assert.IsTrue(result.AsInt() > 0);
}
catch(Exception ex) {
if(log.IsErrorEnabled)
log.Error(ex);
Assert.Fail(ex.Message);
}
}