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

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

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

            return(coll);
        }