You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently views cannot be paged using Simple.Data because they do not have primary keys.
The problem is that keys are really necessary in the SqlQueryPager. Even SqlCe40QueryPager that comes with Simple.Data does not require them. MySql pager would ignore the keys too. And our PostgreSQL pager (found here, forked from the "official" one that seems to be abandoned: https://github.com/ultrico/Simple.Data.PostgreSql ) does not need them either.
Wouldn't it be a good idea to allow paging on tables/views without primary key and move this exception from AdoAdapterQueryRunner to SqlQueryPager ?
Currently views cannot be paged using Simple.Data because they do not have primary keys.
The problem is that keys are really necessary in the SqlQueryPager. Even SqlCe40QueryPager that comes with Simple.Data does not require them. MySql pager would ignore the keys too. And our PostgreSQL pager (found here, forked from the "official" one that seems to be abandoned: https://github.com/ultrico/Simple.Data.PostgreSql ) does not need them either.
Wouldn't it be a good idea to allow paging on tables/views without primary key and move this exception from AdoAdapterQueryRunner to SqlQueryPager ?
https://github.com/markrendle/Simple.Data/blob/master/Simple.Data.Ado/AdoAdapterQueryRunner.cs#L188
The text was updated successfully, but these errors were encountered: