public TblLotCollection FetchByQuery(Query qry)
        {
            TblLotCollection coll = new TblLotCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public TblLotCollection FetchAll()
        {
            TblLotCollection coll = new TblLotCollection();
            Query            qry  = new Query(TblLot.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public TblLotCollection FetchByID(object Id)
        {
            TblLotCollection coll = new TblLotCollection().Where("ID", Id).Load();

            return(coll);
        }