共用方式為

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)

來源:
SqlServerDbContextOptionsBuilder.cs
來源:
SqlServerDbContextOptionsBuilder.cs
來源:
SqlServerDbContextOptionsBuilder.cs
來源:
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

適用於