protected List <T> RunQuerySingleResult <T>(IStoredProcQuery query, string connectionString)
{
var results = new List <T>();
using (var connection = new SqlConnection(connectionString))
{
using (var command = connection.CreateCommand())
{
try
{
QueryHandlerFactory.Create(query).Assign(command, query);
connection.Open();
using (var dataReader = command.ExecuteReader())
{
results = dataReader.FillCollection <T>();
}
}
catch (Exception ex)
{
ErrorHandler.PopulateExceptionWithCommandParameterData(ex, command);
throw;
}
}
}
return(results);
}
protected T RunQueryScalarResult <T>(IStoredProcQuery query, string connectionString)
{
object result = null;
using (var connection = new SqlConnection(connectionString))
{
using (var command = connection.CreateCommand())
{
try
{
QueryHandlerFactory.Create(query).Assign(command, query);
connection.Open();
result = command.ExecuteScalar();
}
catch (Exception ex)
{
ErrorHandler.PopulateExceptionWithCommandParameterData(ex, command);
throw;
}
}
}
return((T)result);
}
protected Tuple <List <T1>, List <T2> > RunQueryDoubleResult <T1, T2>(IStoredProcQuery query, string connectionString)
{
var result1 = new List <T1>();
var result2 = new List <T2>();
using (var connection = new SqlConnection(connectionString))
{
using (var command = connection.CreateCommand())
{
try
{
QueryHandlerFactory.Create(query).Assign(command, query);
connection.Open();
using (var dataReader = command.ExecuteReader())
{
result1 = dataReader.FillCollection <T1>(false);
dataReader.NextResult();
result2 = dataReader.FillCollection <T2>();
}
}
catch (Exception ex)
{
ErrorHandler.PopulateExceptionWithCommandParameterData(ex, command);
throw;
}
}
}
return(new Tuple <List <T1>, List <T2> >(result1, result2));
}
protected void RunQueryNonResult(IStoredProcQuery query, string connectionString)
{
using (var connection = new SqlConnection(connectionString))
{
using (var command = connection.CreateCommand())
{
try
{
QueryHandlerFactory.Create(query).Assign(command, query);
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception ex)
{
ErrorHandler.PopulateExceptionWithCommandParameterData(ex, command);
throw;
}
}
}
}
protected List <T> RunQuerySingleResult <T>(IStoredProcQuery query)
{
return(this.RunQuerySingleResult <T>(query, this.ConnectionString));
}
protected void RunQueryNonResult(IStoredProcQuery query)
{
this.RunQueryNonResult(query, this.ConnectionString);
}
protected T RunQueryScalarResult <T>(IStoredProcQuery query)
{
return(this.RunQueryScalarResult <T>(query, this.ConnectionString));
}
protected Tuple <List <T1>, List <T2>, List <T3> > RunQueryTripleResult <T1, T2, T3>(IStoredProcQuery query)
{
return(this.RunQueryTripleResult <T1, T2, T3>(query, this.ConnectionString));
}
