Example Basic C# Data Accessor/Repository

SimpleCSharpRepository

public class Repository
{
  private ISqlExecutioner _sqlExecutioner;
  private string _connectionString;
  
  public Repository (ISqlExecutioner sqlExecutioner, string connectionString)
  {
    _sqlExecutioner = sqlExecutioner;
    _connectionString = connectionString;
  }
  
  public static DataSet GetSomeStuffFromTheDatabase(int thingId)
  {
    const string PROCEDURE_NAME = "GetMeSomeData";
    var parameterLisst = new SqlParameterList();
    parameterList.Add("@thing_id", SqlDbType.Int, thingId);
    
    return _sqlExecutioner.ExecuteQuery(_connectionString, PROCEDURE_NAME, parameterList);
  }
}