SqlServerIndexBuilderExtensions.SortInTempDb Method

Definition

Namespace:

Microsoft.EntityFrameworkCore

Assembly:

Microsoft.EntityFrameworkCore.SqlServer.dll

Package:

Microsoft.EntityFrameworkCore.SqlServer v8.0.0

Overloads

SortInTempDb(IndexBuilder, Boolean)	Configures whether the index is created with sort in tempdb option when targeting SQL Server.
SortInTempDb(IConventionIndexBuilder, Nullable<Boolean>, Boolean)	Configures whether the index is created with sort in tempdb option when targeting SQL Server.
SortInTempDb<TEntity>(IndexBuilder<TEntity>, Boolean)	Configures whether the index is created with sort in tempdb option when targeting SQL Server.

SortInTempDb(IndexBuilder, Boolean)

Configures whether the index is created with sort in tempdb option when targeting SQL Server.

public static Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder SortInTempDb (this Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder indexBuilder, bool sortInTempDb = true);

static member SortInTempDb : Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder * bool -> Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder

<Extension()>
Public Function SortInTempDb (indexBuilder As IndexBuilder, Optional sortInTempDb As Boolean = true) As IndexBuilder

Parameters

indexBuilder

IndexBuilder

The builder for the index being configured.

sortInTempDb

Boolean

A value indicating whether the index is created with sort in tempdb option.

Returns

IndexBuilder

A builder to further configure the index.

Remarks

See Modeling entity types and relationships, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

SortInTempDb(IConventionIndexBuilder, Nullable<Boolean>, Boolean)

Configures whether the index is created with sort in tempdb option when targeting SQL Server.

public static Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionIndexBuilder? SortInTempDb (this Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionIndexBuilder indexBuilder, bool? sortInTempDb, bool fromDataAnnotation = false);

static member SortInTempDb : Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionIndexBuilder * Nullable<bool> * bool -> Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionIndexBuilder

<Extension()>
Public Function SortInTempDb (indexBuilder As IConventionIndexBuilder, sortInTempDb As Nullable(Of Boolean), Optional fromDataAnnotation As Boolean = false) As IConventionIndexBuilder

Parameters

indexBuilder

IConventionIndexBuilder

The builder for the index being configured.

sortInTempDb

Nullable<Boolean>

A value indicating whether the index is created with sort in tempdb option.

fromDataAnnotation

Boolean

Indicates whether the configuration was specified using a data annotation.

Returns

IConventionIndexBuilder

The same builder instance if the configuration was applied, null otherwise.

Remarks

See Modeling entity types and relationships, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.

SortInTempDb<TEntity>(IndexBuilder<TEntity>, Boolean)

Configures whether the index is created with sort in tempdb option when targeting SQL Server.

public static Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder<TEntity> SortInTempDb<TEntity> (this Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder<TEntity> indexBuilder, bool sortInTempDb = true);

static member SortInTempDb : Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder<'Entity> * bool -> Microsoft.EntityFrameworkCore.Metadata.Builders.IndexBuilder<'Entity>

<Extension()>
Public Function SortInTempDb(Of TEntity) (indexBuilder As IndexBuilder(Of TEntity), Optional sortInTempDb As Boolean = true) As IndexBuilder(Of TEntity)

Type Parameters

TEntity

Parameters

indexBuilder

IndexBuilder<TEntity>

The builder for the index being configured.

sortInTempDb

Boolean

A value indicating whether the index is created with sort in tempdb option.

Returns

IndexBuilder<TEntity>

A builder to further configure the index.

Remarks

See Modeling entity types and relationships, and Accessing SQL Server and Azure SQL databases with EF Core for more information and examples.