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