public GeneralPurchasesTableCollection FetchAll()
 {
     GeneralPurchasesTableCollection coll = new GeneralPurchasesTableCollection();
     Query qry = new Query(GeneralPurchasesTable.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public GeneralPurchasesTableCollection FetchByQuery(Query qry)
 {
     GeneralPurchasesTableCollection coll = new GeneralPurchasesTableCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public GeneralPurchasesTableCollection FetchByID(object GenPurchaseID)
 {
     GeneralPurchasesTableCollection coll = new GeneralPurchasesTableCollection().Where("GenPurchaseID", GenPurchaseID).Load();
     return coll;
 }