Devart Forums

Hi...

I am currently applying 8.11.1172 to my project.
It is applied to the actual product, so it is urgent to correct it. :(

But, if I call Skip () after OrderBy (), an error occurs.
This is different case within #1.
(Using Include statement)

Here is sample
==============================================
List< AnalysisRequest> test = await m_dbContext.AnalysisRequests.AsNoTracking()
.Include(i => i.VirtualDevice)
.OrderBy(i => i.RegDate)
.Skip(1)
.ToListAsync();

Here is query generated by ef
==============================================
query is not display...

Here is stack traces..
==============================================

NNException: [2018-06-25 13:53:14][ERROR][NNException] - System.IndexOutOfRangeException: Result set index too big.
at Devart.Data.MySql.MySqlDataReader.(Int32 , String )
at Devart.Data.MySql.MySqlDataReader.IsDBNull(Int32 i)
at lambda_method(Closure , DbDataReader )
at Microsoft.EntityFrameworkCore.Storage.Internal.TypedRelationalValueBufferFactory.Create(DbDataReader dataReader)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.BufferlessMoveNext(DbContext _, Boolean buffer, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable`1.AsyncEnumerator.MoveNext(CancellationToken cancellationToken)
at System.Linq.AsyncEnumerable.SelectEnumerableAsyncIterator`2.MoveNextCore(CancellationToken cancellationToken)
at System.Linq.AsyncEnumerable.AsyncIterator`1.MoveNext(CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext(CancellationToken cancellationToken)
at System.Linq.AsyncEnumerable.Aggregate_[TSource,TAccumulate,TResult](IAsyncEnumerable`1 source, TAccumulate seed, Func`3 accumulator, Func`2 resultSelector, CancellationToken cancellationToken)
at MSquareProvider.Providers.Optimization.AnalysisProvider.Get(String deviceId, String virtualDeviceId, Int32 skip, Int32 countPerPage, List`1 searchFields, String searchKeyword, Nullable`1 searchStartDate, Nullable`1 searchEndDate, EnumAnalysisStatus status) in D:\Source\NewMSquare\MSquare\Models\MSquareProvider\Providers\Optimization\AnalysisProvider.cs:line 90

Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.

The bug with paging in EF Core 2.1 is fixed. The internal build with the fix: https://www.devart.com/pub/nuget_mysql_8_11_1186.zip.

dotConnect for MySQL 8.12 is released: viewtopic.php?f=2&t=37477.