public IEnumerable <LogRecord> GetRecords(int numberOfRecords, long?recordId, bool showHeader = false)
{
if (dbConnection == null)
{
dbConnection = _connectionWrapper.CreateConnection();
}
if (dbConnection.State == ConnectionState.Closed)
{
dbConnection.Open();
}
var prm = new DynamicParameters();
prm.Add("@recordlimit", numberOfRecords);
prm.Add("@recordid", recordId);
var reader = dbConnection.ExecuteReader(defaultStoredProcedure, prm, commandType: CommandType.StoredProcedure);
if (showHeader)
{
yield return(GetSingleEntry(reader, true));
}
while (reader.Read())
{
yield return(GetSingleEntry(reader));
}
}
public DbConnection CreateConnection()
{
// create a connection for operations that require holding an open connection to the db
return(_connectionWrapper.CreateConnection());
}
