public TransactionsExternalCollection FetchAll()
 {
     TransactionsExternalCollection coll = new TransactionsExternalCollection();
     Query qry = new Query(TransactionsExternal.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public TransactionsExternalCollection FetchByQuery(Query qry)
 {
     TransactionsExternalCollection coll = new TransactionsExternalCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public TransactionsExternalCollection FetchByID(object TxExternalKey)
 {
     TransactionsExternalCollection coll = new TransactionsExternalCollection().Where("tx_external_key", TxExternalKey).Load();
     return coll;
 }