How do Get this work with SQL server 2008?

[neilhanekom]

I am getting the following error when I view the clients or any other list pages on Admin UI. SqlException: Incorrect syntax near 'OFFSET'.

[skoruba]

You can try to add UseRowNumberForPaging -> optionsBuilder.UseSqlServer(connectionString, builder => builder.UseRowNumberForPaging());