Invalid usage of the option NEXT in the FETCH statement

[sgjsakura]

Invalid usage of the option NEXT in the FETCH statement

[sgjsakura]

@sylvaincaillot Hi, thank you for your feed back, this problem may caused by the EntityFramework Core library but not by the pager. Please try to remove the ToPagedList invokation and replace it with Skip and Take, e.g.

var result = (from i in myModel select i).Skip(10).Take(10);

If the problem still occurs, it then can be confirmed this problem is caused by EntityFramework. Please report this issue to the ASP.NET Core development team thought https://github.com/aspnet/EntityFramework/issues .While if the problem does not occur again, please let me know as soon as possible.

Thank you again and waiting for your kind reply :-)

[sylvaincaillot]

Thnak you @sgjsakura for your quick reply

I followed your advices and got the same error for the following:

IQueryable<SearchResultViewModel> SearchVM = (from item in _context.MyModel
                                                         select new SearchResultViewModel()
                                                         {
                                                             A = item.a,
                                                                B= item.b
                                                         }).Skip(10).Take(10);

            model.SearchResults = SearchVM.ToList();
            return model;

If I remove the .Skip(10).Take(10), it works fine...

Using SQL Server 2008 R2, I needed to add UseRowNumberForPaging in my context as suggested here

 optionsBuilder.UseSqlServer(_config["ConnectionStrings:MyConnection"], b => b.UseRowNumberForPaging());

Cheers

S.