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