public void Store(TestResult testResult) { using ( var storedProcedure = new StoredProcedure(DataBase.Default, "sp_InsertResults", SetUpResultParameters(testResult))) { storedProcedure.Execute(); } }
public List<DatabaseConnection> Get() { var connections = new List<DatabaseConnection>(); using ( var storedProcedure = new StoredProcedure(DataBase.Default, "sp_getConnections")) { SqlDataReader reader = storedProcedure.GetDataReader(); while (reader.Read()) { DatabaseConnection connection = SetUpDatabaseConnection(reader); connections.Add(connection); } } return connections; }