static void Main4(string[] args)
{
Console.WriteLine("Testing ExecuteValues function");
ISqlSimpleAccess simpleAccess = new SqlSimpleAccess("sqlDefaultConnection");
SqlTransaction transaction = null;
try
{
var data = simpleAccess.ExecuteValues <string>("Select Name from Category;");
using (transaction = simpleAccess.BeginTrasaction())
{
data = simpleAccess.ExecuteValues <string>(transaction, "Select Name from Category;");
simpleAccess.EndTransaction(transaction);
}
}
catch (Exception e)
{
simpleAccess.EndTransaction(transaction, false);
throw;
}
Console.WriteLine("Press any key to close.");
Console.ReadKey();
}
static void Main2(string[] args)
{
ConstructorTests();
ISqlSimpleAccess simpleAccess = new SqlSimpleAccess("defaultConnection");
SqlTransaction transaction = null;
try
{
using (transaction = simpleAccess.BeginTrasaction())
{
var person = new Person()
{
Name = "Ahmed", Address = "Madina"
};
var newId = simpleAccess.ExecuteScalar <int>(transaction, "INSERT INTO People Values (@name, @Address); SELECT SCOPE_IDENTITY();", person);
simpleAccess.EndTransaction(transaction);
}
}
catch (Exception)
{
simpleAccess.EndTransaction(transaction, false);
throw;
}
//TestTextCommandSimpleAccess(GetTextQuerySimpleAccess());
//TestSotredProcedureCommandSimpleAccess(GetStroedProcedureSimpleAccess());
TestSotredProcedureCommandSimpleAccessRepository();
Console.WriteLine("Press any key to close.");
Console.ReadKey();
}
