public override IQueryable <CustomerDepartment> GetCustomerDepartmentQuery()
        {
            IQueryable <CustomerDepartment> query = CustomerDepartments
                                                    .OrderBy(d => d.CustomerId)
                                                    .ThenBy(d => d.DepartmentName)
                                                    .ThenBy(d => d.Id);

            return(query);
        }
        /// <summary>
        /// Default query for CustomerDepartments
        /// </summary>
        /// <returns></returns>
        public virtual IQueryable <CustomerDepartment> GetCustomerDepartmentQuery()
        {
            IQueryable <CustomerDepartment> query = CustomerDepartments.OrderBy(p => p.DepartmentName);

            return(query);
        }