public TransactionStatusCollection FetchAll()
 {
     TransactionStatusCollection coll = new TransactionStatusCollection();
     Query qry = new Query(TransactionStatus.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public TransactionStatusCollection FetchByQuery(Query qry)
 {
     TransactionStatusCollection coll = new TransactionStatusCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public TransactionStatusCollection FetchByID(object TransactionStatusKey)
 {
     TransactionStatusCollection coll = new TransactionStatusCollection().Where("transaction_status_key", TransactionStatusKey).Load();
     return coll;
 }