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