/// <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(); }