Hello,
Whenever I build an blazor app (web assembly) with database in sql server 2008 R2 using paging the results I am getting the error unable to fetch data incorrect [Incorrect syntax near OFFSET command]
The radzen uses the Microsoft.AspNetOData 7.5 to apply query using the OData.
The problem however is that using the query option $skip and $top the query to sql server
uses the sql commands
OFFSET 10 ROWS
FETCH NEXT 10 ROWS ONLY;
These commands are supported in SQL Server 2008 but only after the sql server 2012.
Of course this problem does not exist when I use database compatible with sql server 2012 and after.
Do you have any suggestions how paging can be apply into sql server 2008?
Any suggestion?
Thanks,