Sorting Gridview with Entity Framework Not Working as Intended

Question

I have a gridview that i want to sort. I wrote the following method for it:

private void SortGridView(string sortExpression, string direction)
    {
        var constr = new AdminRequirementEF();
        string sort = string.Concat("it.", sortExpression, " ", direction);
        int pageSize = Convert.ToInt32(ddPageSize.SelectedItem.Text);

        var results = constr.Projects;
        int totalRecords = results.Count();
        this.PopulatePager(totalRecords, pageIndex);

        var sortedResults = constr.Projects.OrderBy(sort).Skip((pageIndex - 1) * pageSize).Take(pageNum).ToList();
        grdMain.DataSource = sortedResults;
        grdMain.DataBind();
    }

The problem is sorting is applied on totalrecords not on per page filtered records. I want to use OrderBy(sort) after applying skip and take but it gives me an error stating skip can not be applied before orderby clause. Any help will be much appreciated.

Which EF version is this? This should work alright. What does the generated SQL look like? — Gert Arnold
– Gert Arnold, Commented Dec 25, 2013 at 20:56

Jhabar · Accepted Answer · 2013-12-25 11:19:11Z

1

You can get the constr.Projects collection sorted on its primary key

var results = constr.Projects.OrderBy(p => p.ProjectId)

and then apply the skip and take on the 'results' collection with sorting.

results = results.Skip((pageIndex - 1) * pageSize).Take(pageNum).OrderBy(sort).ToList();

This way you will get the records for particular page sorted as required.

answered Dec 25, 2013 at 11:19

Jhabar

1291 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

biki Over a year ago

No its not working, tried this before.I guess Orderby(string value) cant be applied after Skip-Take.

Collectives™ on Stack Overflow

Sorting Gridview with Entity Framework Not Working as Intended

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related