public LDepartmentCollection FetchByQuery(Query qry)
        {
            var coll = new LDepartmentCollection();

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }
        public LDepartmentCollection FetchAll()
        {
            var coll = new LDepartmentCollection();
            var qry  = new Query(LDepartment.Schema);

            coll.LoadAndCloseReader(qry.ExecuteReader());
            return(coll);
        }