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