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

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

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

            return(coll);
        }