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