SqlServerIndexBuilderExtensions.SortInTempDb Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 IndexBuilderParameters
- 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
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)
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 IConventionIndexBuilderParameters
- indexBuilder
- IConventionIndexBuilder
The builder for the index being configured.
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
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)
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
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
Entity Framework
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for