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

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

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

            return(coll);
        }