Paging is broken when dxDataGrid is sorted by a column with non-unique values about devextreme.aspnet.data

[jtheisen]

I wrote up why this is in the ticket I filed on devexpress.com - I think that will be helpful.

[AlekseyMartynov]

Thanks @jtheisen for reporting this.
The worst thing is that there's no universal way to automatically deternime primary key properties, because the concept of primary keys doesn't belong to pure LINQ.

I think we need to add DataSourceLoadOptions.PrimaryKey property of type String[] and also try to populate keys automatically from data annotation attributes if they are available.

As it turns out, the DefaultSort prop doesn't work and probably needs to be deprecated.

We are working on a fix.

[AlekseyMartynov]

PR is ready: #83

[liuyuanjie]

Per your description, I think you need to read the article which is talking about Using OFFSET and FETCH to limit the rows returned for better understanding. Please see:
Using OFFSET and FETCH to limit the rows returned