語言

SqlServerDbContextOptionsBuilder.UseRowNumberForPaging 方法

定義

多載

名稱 Description
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

傳回

屬性

適用於