public InternalPurchaseTableCollection FetchAll()
 {
     InternalPurchaseTableCollection coll = new InternalPurchaseTableCollection();
     Query qry = new Query(InternalPurchaseTable.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public InternalPurchaseTableCollection FetchByQuery(Query qry)
 {
     InternalPurchaseTableCollection coll = new InternalPurchaseTableCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public InternalPurchaseTableCollection FetchByID(object Id)
 {
     InternalPurchaseTableCollection coll = new InternalPurchaseTableCollection().Where("ID", Id).Load();
     return coll;
 }