/// <summary>
/// Fetches the complete set of elements and returns this set as an IEnumerable.
/// </summary>
/// <returns>the set fetched</returns>
public override IEnumerable <SalesOrderHeader> FetchSet()
{
var headers = new List <SalesOrderHeader>();
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
headers = dbFactory.Fetch <SalesOrderHeader>(CommandText);
dbFactory.CloseSharedConnection();
return(headers);
}
/// <summary>
/// Fetches the individual element
/// </summary>
/// <param name="key">The key of the element to fetch.</param>
/// <returns>The fetched element, or null if not found</returns>
public override SalesOrderHeader FetchIndividual(int key)
{
SalesOrderHeader toReturn = null;
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
toReturn = dbFactory.First <SalesOrderHeader>(CommandText + " where SalesOrderId=@0", key);
dbFactory.CloseSharedConnection();
return(toReturn);
}
/// <summary>
/// Fetches the complete set of elements and returns this set as an IEnumerable.
/// </summary>
/// <returns>the set fetched</returns>
public override IEnumerable <SalesOrderHeader> FetchSet()
{
var headers = new List <SalesOrderHeader>();
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
dbFactory.EnableAutoSelect = false;
dbFactory.EnableNamedParams = false;
dbFactory.ForceDateTimesToUtc = false;
headers = dbFactory.Fetch <SalesOrderHeader>(CommandText);
dbFactory.CloseSharedConnection();
return(headers);
}
/// <summary>
/// Fetches the individual element
/// </summary>
/// <param name="key">The key of the element to fetch.</param>
/// <returns>The fetched element, or null if not found</returns>
public override SalesOrderHeader FetchIndividual(int key)
{
SalesOrderHeader toReturn = null;
var dbFactory = new PetaPoco.Database(ConnectionStringToUse, "System.Data.SqlClient");
dbFactory.OpenSharedConnection();
dbFactory.EnableAutoSelect = false;
dbFactory.EnableNamedParams = false;
dbFactory.ForceDateTimesToUtc = false;
toReturn = dbFactory.First <SalesOrderHeader>(CommandText + " where SalesOrderId=@0 ", key);
dbFactory.CloseSharedConnection();
return(toReturn);
}
/// <summary>
/// Dispose the grid, closing and disposing both the underlying reader, command and shared connection
/// </summary>
public void Dispose()
{
if (_reader != null)
{
if (!_reader.IsClosed && _command != null)
{
_command.Cancel();
}
_reader.Dispose();
_reader = null;
}
if (_command != null)
{
_command.Dispose();
_command = null;
}
_db.CloseSharedConnection();
}
