Share via

SqlServerDbContextOptionsBuilder.UseRowNumberForPaging Method

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore.Infrastructure
Assembly:
Microsoft.EntityFrameworkCore.SqlServer.dll
Package:
Microsoft.EntityFrameworkCore.SqlServer v1.0.6
Package:
Microsoft.EntityFrameworkCore.SqlServer v1.1.6
Package:
Microsoft.EntityFrameworkCore.SqlServer v2.0.3
Package:
Microsoft.EntityFrameworkCore.SqlServer v2.1.11
Package:
Microsoft.EntityFrameworkCore.SqlServer v2.2.6
Package:
Microsoft.EntityFrameworkCore.SqlServer v3.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v3.1.0

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)

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

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

SqlServerDbContextOptionsBuilder
Attributes
ObsoleteAttribute

Applies to