Share via


SqlServerDbContextOptionsBuilder.UseRowNumberForPaging Method

Definition

Overloads

UseRowNumberForPaging()

Use a ROW_NUMBER() in queries instead of OFFSET/FETCH. This method is backwards-compatible to SQL Server 2005.

UseRowNumberForPaging(Boolean)
Obsolete.

Use a ROW_NUMBER() in queries instead of OFFSET/FETCH. This method is backwards-compatible to SQL Server 2005.

UseRowNumberForPaging()

Use a ROW_NUMBER() in queries instead of OFFSET/FETCH. This method is backwards-compatible to SQL Server 2005.

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

Applies to

UseRowNumberForPaging(Boolean)

Caution

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

Use a ROW_NUMBER() in queries instead of OFFSET/FETCH. This method is backwards-compatible to 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

Parameters

useRowNumberForPaging
Boolean

Returns

Attributes

Applies to