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();
}
public static void RunSimpleAccess()
{
var simpleAccess = new SqlSimpleAccess(ConnectionString);
var query = "SELECT ID, CityId, Name, PhoneNumbers,Address ,Address2 FROM BRANCHES";
for (int i = 0; i < 500; i++)
{
var branch = simpleAccess.ExecuteEntity <Branch>(query);
var b = branch != null;
}
}
public static void ConstructorTests()
{
ISqlSimpleAccess simpleAccess = new SqlSimpleAccess("sqlDefaultConnection");
simpleAccess = new SqlSimpleAccess("Data Source=.\\SQLEXPRESS2014;Initial Catalog=SimpleAccessTest;Persist Security Info=True;User ID=sa;Password=test");
}
