public BillingCityRateCollection FetchAll()
 {
     BillingCityRateCollection coll = new BillingCityRateCollection();
     Query qry = new Query(BillingCityRate.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public BillingCityRateCollection FetchAllActive()
 {
     BillingCityRateCollection coll = new BillingCityRateCollection();
     Query qry = new Query(BillingCityRate.Schema);
     qry.WHERE(BillingCityRate.Columns.IsDeleted, false);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public BillingCityRateCollection FetchByQuery(Query qry)
 {
     BillingCityRateCollection coll = new BillingCityRateCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public BillingCityRateCollection FetchByID(object Id)
 {
     BillingCityRateCollection coll = new BillingCityRateCollection().Where("id", Id).Load();
     return coll;
 }