通过

SqlServerDbContextOptionsBuilder.UseRowNumberForPaging 方法

  • 参考

定义

命名空间:
Microsoft.EntityFrameworkCore.Infrastructure
程序集:
Microsoft.EntityFrameworkCore.SqlServer.dll
包:
Microsoft.EntityFrameworkCore.SqlServer v1.0.6
包:
Microsoft.EntityFrameworkCore.SqlServer v1.1.6
包:
Microsoft.EntityFrameworkCore.SqlServer v2.0.3
包:
Microsoft.EntityFrameworkCore.SqlServer v2.1.11
包:
Microsoft.EntityFrameworkCore.SqlServer v2.2.6
包:
Microsoft.EntityFrameworkCore.SqlServer v3.0.0
包:
Microsoft.EntityFrameworkCore.SqlServer v3.1.0

重载

UseRowNumberForPaging()

在查询中使用 ROW_NUMBER () ，而不是 OFFSET/FETCH。 此方法与 SQL Server 2005 向后兼容。
UseRowNumberForPaging(Boolean)
已过时.

在查询中使用 ROW_NUMBER () ，而不是 OFFSET/FETCH。 此方法与 SQL Server 2005 向后兼容。

UseRowNumberForPaging()

在查询中使用 ROW_NUMBER () ，而不是 OFFSET/FETCH。 此方法与 SQL Server 2005 向后兼容。

public virtual void UseRowNumberForPaging ();
abstract member UseRowNumberForPaging : unit -> unit
override this.UseRowNumberForPaging : unit -> unit
Public Overridable Sub UseRowNumberForPaging ()

适用于

UseRowNumberForPaging(Boolean)

Source:
SqlServerDbContextOptionsBuilder.cs
Source:
SqlServerDbContextOptionsBuilder.cs
Source:
SqlServerDbContextOptionsBuilder.cs
Source:
SqlServerDbContextOptionsBuilder.cs

注意

Row-number paging is no longer supported. See https://ak.ms/AA6h122 for more information.

在查询中使用 ROW_NUMBER () ，而不是 OFFSET/FETCH。 此方法与 SQL Server 2005 向后兼容。

public virtual void UseRowNumberForPaging (bool useRowNumberForPaging = true);
public virtual Microsoft.EntityFrameworkCore.Infrastructure.SqlServerDbContextOptionsBuilder UseRowNumberForPaging (bool useRowNumberForPaging = true);
[System.Obsolete("Row-number paging is no longer supported. See https://ak.ms/AA6h122 for more information.")]
public virtual Microsoft.EntityFrameworkCore.Infrastructure.SqlServerDbContextOptionsBuilder UseRowNumberForPaging (bool useRowNumberForPaging = true);
abstract member UseRowNumberForPaging : bool -> unit
override this.UseRowNumberForPaging : bool -> unit
abstract member UseRowNumberForPaging : bool -> Microsoft.EntityFrameworkCore.Infrastructure.SqlServerDbContextOptionsBuilder
override this.UseRowNumberForPaging : bool -> Microsoft.EntityFrameworkCore.Infrastructure.SqlServerDbContextOptionsBuilder
[<System.Obsolete("Row-number paging is no longer supported. See https://ak.ms/AA6h122 for more information.")>]
abstract member UseRowNumberForPaging : bool -> Microsoft.EntityFrameworkCore.Infrastructure.SqlServerDbContextOptionsBuilder
override this.UseRowNumberForPaging : bool -> Microsoft.EntityFrameworkCore.Infrastructure.SqlServerDbContextOptionsBuilder
Public Overridable Sub UseRowNumberForPaging (Optional useRowNumberForPaging As Boolean = true)
Public Overridable Function UseRowNumberForPaging (Optional useRowNumberForPaging As Boolean = true) As SqlServerDbContextOptionsBuilder

参数

useRowNumberForPaging
Boolean

返回

SqlServerDbContextOptionsBuilder
属性
ObsoleteAttribute

适用于