Generic OrderBy

Question

I'm new on development and want to make a small change by adding orderby to the existing code. Can someone enlighten me on how to orderby to this piece of code?

    public List<Employee> GetAllEmployees()
    {
        ebll employeeBll = new EmployeeBLL();
        return ebll.GetAllEmployees();
    }

Why can't you just read LINQ documentation? `ebll.GetAllEmployees().OrderBy(emp => emp.Name)` — codingbiz, Jun 03 '15 at 04:12
http://stackoverflow.com/questions/188141/list-orderby-alphabetical-order — codingbiz, Jun 03 '15 at 04:17

T.S. · Answer 1 · 2015-06-03T16:04:21.933

0

Set reference to Linq before doing this. I used employee LastName for order by

public List<Employee> GetAllEmployees()
{
    ebll employeeBll = new EmployeeBLL();
    return ebll.GetAllEmployees().OrderBy(e => e.LastName).ToList();
}

edited Jun 03 '15 at 16:04

answered Jun 03 '15 at 04:16

T.S.

18,195
11
58
78

score 0 · Answer 2 · answered Jun 03 '15 at 04:43

I agree with the answer that T.S. gave, however I would modify to return an IQueryable instead of returning the a .ToList() if you want to leave the option to further filter the list in the calling method. For example GetAllEmployees().Where(e=>e.Name="Brad") otherwise you are enumerating the list early and not taking advantage of using the underlying data source to do the heavy lifting of filtering therefore returning more data than is needed.

Generic OrderBy

2 Answers2