SqlServerIndexBuilderExtensions.SortInTempDb Method

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore
Assembly:
Microsoft.EntityFrameworkCore.SqlServer.dll
Package:
Microsoft.EntityFrameworkCore.SqlServer v8.0.0
Package:
Microsoft.EntityFrameworkCore.SqlServer v9.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)

Source:
SqlServerIndexBuilderExtensions.cs
Source:
SqlServerIndexBuilderExtensions.cs

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.

Applies to

SortInTempDb(IConventionIndexBuilder, Nullable<Boolean>, Boolean)

Source:
SqlServerIndexBuilderExtensions.cs
Source:
SqlServerIndexBuilderExtensions.cs

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.

Applies to

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

Source:
SqlServerIndexBuilderExtensions.cs
Source:
SqlServerIndexBuilderExtensions.cs

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.

Applies to