DataGrid error when using pagination

Radzen.Blazor Components
1

The following error occurs when using AllowPaging="true" on datagrid using .Net 8:

SqlException: Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement.

We had to remove UseRowNumberForPaging() from the DbContextOptionsBuilder as it is no longer supported in .Net 8

Is this a bug which will be fixed, or we need to use a workaround?

2

What’s your SQL server version?

3

The SQL Version we're using is MS SQL 2008

4

This isn't a bug as Entity Framework does not support MSSQL 2008 (you need at least MSSQL 2012). We would recommend upgrading.

5

I moved the data to SQL 2019 Express and still the error persists.
The problem seems to popped up when we upgraded some NuGet items to ver 8 and the .Net ver to 8

6

I moved the data to SQL 2019 Express and still the error persists.
The problem seems to popped up when we upgraded some NuGet items to ver 8 and the .Net ver to 8

Any new about this problem please?

7

The problem isn't related to the Radzen.Blazor component library and we don't have any other suggestions.