Hi,
We are using aspnetzero V5, But we are facing some issues.
Please help us to solve this.
[*]Error In GetUsers(InternalserverError) we found error in this code block
var users = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
Excelption
Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
[*] Also get Error In these methods. * GetLinkedUsers * GetUserNotifications
Thanks
13 Answer(s)
-
0
Are you on v5.0.3?
-
0
Hi,
Yes, Its 5.0.3
Thanks
-
0
Can you try v5.0.4?
-
0
Hi @velu,
Are you using a different database than Ms Sql ? (Oracle or MySql )database ? If so, have you regenerated all migrations ?
-
0
Hi,
We are trying to start application first, That Why we are first use msSQL 2008
all below errors are in MSSQL2008 and v5.03
Thanks
-
0
Hi,
We are using aspnetzero V5.0.0.0 and Angular 5.0.3.
Dear Aaron,
What do you mean by upgrade to v 5.0.4?
Thanks
-
0
aspnetzero v5.0.4 (for ASP.NET Core & Angular) is available for download.
Sorry for the confusion, I wasn't aware that Angular's latest version is v5.0.3.
-
0
Hi Aaron,
Please guide us on:
- How to migrate existing solition.
Or We download fresh zip from aspnetzero website..
Thanks
-
0
Yes, download fresh zip from aspnetzero website.
How to migrate existing solution: https://github.com/aspnetzero/aspnet-zero/issues/96#issuecomment-268093697
-
0
We will download the aspnetzero v5.0.4 (for ASP.NET Core & Angular) and will do the necessary checking. If any problem we will get back to you.
-
0
If you are using MSSQL 2008 you need to change out your context, EF core defaults to 2012+ standards that have an offset.
In EF project, in the configure file you need to add the "UseRowNumberForPaging()" option.
public static void Configure(DbContextOptionsBuilder<PlatformDbContext> builder, string connectionString) { builder.UseSqlServer(connectionString, o => o.UseRowNumberForPaging()); } -
0
HI,
We try all methods, Still, We are facing the same issue....
Exception :
Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement.Please check log file.... <a class="postlink" href="https://drive.google.com/open?id=1sa16aNFBSrnxh3skviYBLterwgmqAfd5">https://drive.google.com/open?id=1sa16a ... erwgmqAfd5</a>
Request you to solve this issues.
Thanks.
-
0
Hi,
@ BBakerMMC
Thank You So much for the suggestion,
After making these changed in the application, Its working fine...
Thanks.
