dynamic order by different column and table

Question

Hello All,

we are trying to add dynamic Order by different column in multiple tables. we will get column name and have to sort data.
for example I want sort Department.Name or Staff=> JoiningDate . I tried different options and didn't work. not sure how to implement.

Below mentioned column need to sort.
Column Name: Department => Name
Column Name: Staff=> JoiningDate

public void getDepartment(String orderBy){
_context.Get<Department>()
           .Include(department => department.Staff); 
}
     

Answer 1

Hi smjejess-2326,
Have you tried the Dynamic Linq?
Please refer to the following threads:
Linq To SQL: Sort Query by Arbitrary Property(Column) Name
How does one sort using Entity Framework Dynamic “SortBy” string on a complex object?
Dynamic LINQ OrderBy on IEnumerable<T> / IQueryable<T>
Best Regards,
Daniel Zhang

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.