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