EFCore 6.0 适配 SqlServer2005-2008 分页查询 SqlServer2008OffsetToRowNumberConvertVisitor 报错

> 💢 特别说明：如果 Issue 没有严格按照模板编写且未提供测试源码下载或 Git 测试仓库地址，则视为无效 `Issue`。

### Furion 版本号

哪个版本号？
3.0.1
---

### Web 项目类型

- [x] WebApi
- [ ] Mvc
- [ ] Razor Pages
- [ ] Blazor Server
- [ ] MinApp

---

### 描述你的问题

发生了什么？

https://github.com/dotnet/efcore/blob/main/src/EFCore.Relational/Query/SqlExpressions/SelectExpression.cs#L3023

EFCore6的GenerateOuterColumn参数改变了导致

https://gitee.com/dotnetchina/Furion/blob/net6/framework/Furion/DatabaseAccessor/SqlServer2005-2008/SqlServer2008OffsetToRowNumberConvertVisitor.cs#L40

兼容2008分页的适配方法报错
---

### 异常堆栈信息

异常堆栈是什么？

```
System.TypeInitializationException: The type initializer for 'Microsoft.EntityFrameworkCore.Query.SqlServer2008OffsetToRowNumberConvertVisitor' threw an exception.
 ---> System.ArgumentException: Cannot bind to the target method because its signature is not compatible with that of the delegate type.
   at System.Reflection.RuntimeMethodInfo.CreateDelegateInternal(Type delegateType, Object firstArgument, DelegateBindingFlags bindingFlags)
   at System.Reflection.RuntimeMethodInfo.CreateDelegate(Type delegateType)
   at Microsoft.EntityFrameworkCore.Query.SqlServer2008OffsetToRowNumberConvertVisitor..cctor() in D:\Code\Test\Furion\framework\Furion\DatabaseAccessor\SqlServer2005-2008\SqlServer2008OffsetToRowNumberConvertVisitor.cs:line 49
   --- End of inner exception stack trace ---
   at Microsoft.EntityFrameworkCore.Query.SqlServer2008OffsetToRowNumberConvertVisitor..ctor(Expression root, ISqlExpressionFactory sqlExpressionFactory) in D:\Code\Test\Furion\framework\Furion\DatabaseAccessor\SqlServer2005-2008\SqlServer2008OffsetToRowNumberConvertVisitor.cs:line 57
   at Microsoft.EntityFrameworkCore.Query.SqlServer2008QueryTranslationPostprocessor.Process(Expression query) in D:\Code\Test\Furion\framework\Furion\DatabaseAccessor\SqlServer2005-2008\SqlServer2008QueryTranslationPostprocessor.cs:line 37
   at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
   at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass12_0`1.<ExecuteAsync>b__0()
   at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsync[TResult](Expression query, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ExecuteAsync[TSource,TResult](MethodInfo operatorMethodInfo, IQueryable`1 source, Expression expression, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ExecuteAsync[TSource,TResult](MethodInfo operatorMethodInfo, IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.CountAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Furion.DatabaseAccessor.PagedQueryableExtensions.ToPagedListAsync[TEntity](IQueryable`1 entities, Int32 pageIndex, Int32 pageSize, CancellationToken cancellationToken) in D:\Code\Test\Furion\framework\Furion\DatabaseAccessor\Extensions\PagedQueryableExtensions.cs:line 0
   at U8Api.UnitService.GetAllByPage(Int32 pageIndex, Int32 pageSize) in D:\Code\BEST\U8Api\U8Api\Services\BaseData\UnitService.cs:line 47
   at lambda_method8(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|26_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)

```
---

### 测试项目代码

> **⚠⚠ 必须提供完整可运行且包含错误的 `Git` 仓库 DEMO，DEMO 提供最简单的错误逻辑代码，否则不予处理。⚠⚠**

您的代码下载地址？

---

### 数据库信息

- [ ] Sqlite
- [x] SqlServer
- [x] Mysql
- [ ] Oracle
- [ ] PGSql
- [ ] Firebird
- [ ] Cosmos

---

### 期待结果

期待的结果是？
正常使用2008分页查询
---

### 关注 Furion

你给的 star，胜过所有读过的诗。✨

---

GVP dotNET China/Furion

内容风险标识

评论 (14)

GVPdotNET China/Furion

内容风险标识