about OrderByDescending(m => m.RechargeDate).Skip(10).Take(10) about linq2db.entityframeworkcore HOT 20 CLOSED

     var qry = from memberApply in Db.MemberApply
                          from branch in Db.BranchInfo
                          where branch.BranchCode == memberApply.BranchCode
                                && branch.BranchId == id
                                && memberApply.HandleStatus == 1
                          from wxAttention in Db.WxAttention.LeftJoin(wx => wx.WxopenId == memberApply.WxopenId)
                          select new MemberApplyListOutput
                          {
                              ApplyBirthday = memberApply.ApplyBirthday,
                              Wxavatar = wxAttention.Wxavatar,
                              ApplyId = memberApply.ApplyId,
                              ApplyName = memberApply.ApplyName,
                              ApplySex = memberApply.ApplySex,
                              ApplyTelPhone = memberApply.ApplyTelPhone,
                              BranchName = memberApply.BranchName,
                              CreateTime = memberApply.CreateTime,
                              OpenCardEmpName = memberApply.OpenCardEmpName,
                          };

                result.Count = await qry.ToLinqToDB().CountAsync();
                result.Data = await qry.OrderByDescending(m => m.CreateTime).Skip((page - 1) * pageSize).Take(pageSize).ToLinqToDB().ToListAsync();

  public HYWCRMContext(string connectionString) : base(new DbContextOptionsBuilder<HYWCRMContext>()
            .UseSqlServer(connectionString, b => b.UseRowNumberForPaging()).Options)
        {

        }

2018-08-13 11:32:59.1905|-2146232060|Hyw.Api.Empl.Infrastructure.Filters.HttpGlobalExceptionFilter|ERROR|'OFFSET' 附近有语法错误。
在 FETCH 语句中选项 NEXT 的用法无效。 System.Data.SqlClient.SqlException (0x80131904): 'OFFSET' 附近有语法错误。
在 FETCH 语句中选项 NEXT 的用法无效。
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__122_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
--- End of stack trace from previous location where exception was thrown ---
   at LinqToDB.Data.DataConnection.ExecuteReaderAsync(CommandBehavior commandBehavior, CancellationToken cancellationToken) in C:\projects\linq2db\Source\LinqToDB\Data\DataConnection.Async.cs:line 165
   at LinqToDB.Data.DataConnection.QueryRunner.ExecuteReaderAsync(CancellationToken cancellationToken) in C:\projects\linq2db\Source\LinqToDB\Data\DataConnection.QueryRunner.cs:line 471
   at LinqToDB.Linq.QueryRunner.AsyncEnumeratorImpl`1.MoveNext(CancellationToken cancellationToken) in C:\projects\linq2db\Source\LinqToDB\Linq\QueryRunner.cs:line 441
   at System.Linq.AsyncEnumerable.Aggregate_[TSource,TAccumulate,TResult](IAsyncEnumerable`1 source, TAccumulate seed, Func`3 accumulator, Func`2 resultSelector, CancellationToken cancellationToken)
   at LinqToDB.AsyncExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken token) in C:\projects\linq2db\Source\LinqToDB\AsyncExtensions.cs:line 149
   at Hyw.QueryServices.EFCore.MemberApplyQuery.GetListByIdAndTypeAsync(Int32 id, Int32 type, Int32 page, Int32 pageSize) in D:\VsProjects\Hyw2\src\Hyw.QueryServices.EFCore\MemberApplyQuery.cs:line 85
   at Hyw.Api.Empl.Controllers.MemberApplyController.Get(BaseModel model, PageModel page) in D:\VsProjects\Hyw2\hosts\Hyw.Api.Empl\Controllers\MemberApplyController.cs:line 47
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at System.Threading.Tasks.ValueTask`1.get_Result()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextExceptionFilterAsync()
ClientConnectionId:c929e8de-6826-4ad8-8266-caaab0e55729
Error Number:102,State:1,Class:15

        public static void Main(string[] args)
        {
            NLog.LogManager.LoadConfiguration("NLog.config");
            CreateWebHostBuilder(args).Build().Run();
        }

        public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
            WebHost.CreateDefaultBuilder(args)
                .ConfigureLogging(logging =>
                {
                    logging.ClearProviders();
                    logging.SetMinimumLevel(LogLevel.Trace);
                })
                .UseNLog()
                .UseStartup<Startup>();