SqlServerIndexBuilderExtensions Class

Definition

SQL Server specific extension methods for IndexBuilder.

public static class SqlServerIndexBuilderExtensions
type SqlServerIndexBuilderExtensions = class
Public Module SqlServerIndexBuilderExtensions
Inheritance
SqlServerIndexBuilderExtensions

Remarks

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

Methods

CanSetDataCompression(IConventionIndexBuilder, Nullable<DataCompressionType>, Boolean)

Returns a value indicating whether the index can be configured with data compression option when targeting SQL Server.

CanSetFillFactor(IConventionIndexBuilder, Nullable<Int32>, Boolean)

Returns a value indicating whether the index can be configured with fill factor option when targeting SQL Server.

CanSetIncludeProperties(IConventionIndexBuilder, IReadOnlyList<String>, Boolean)

Returns a value indicating whether the given include properties can be set.

CanSetIsClustered(IConventionIndexBuilder, Nullable<Boolean>, Boolean)

Returns a value indicating whether the index can be configured as clustered.

CanSetIsCreatedOnline(IConventionIndexBuilder, Nullable<Boolean>, Boolean)

Returns a value indicating whether the index can be configured with online option when targeting SQL Server.

CanSetSortInTempDb(IConventionIndexBuilder, Nullable<Boolean>, Boolean)

Returns a value indicating whether the index can be configured with sort in tempdb option when targeting SQL Server.

ForSqlServerHasName(IndexBuilder, String)

Configures the name of the index in the database when targeting SQL Server.

ForSqlServerInclude(IConventionIndexBuilder, IReadOnlyList<String>, Boolean)
Obsolete.

Configures index include properties when targeting SQL Server.

ForSqlServerInclude(IndexBuilder, String[])
Obsolete.

Configures index include properties when targeting SQL Server.

ForSqlServerInclude<TEntity>(IndexBuilder<TEntity>, Expression<Func<TEntity,Object>>)
Obsolete.

Configures index include properties when targeting SQL Server.

ForSqlServerIsClustered(IConventionIndexBuilder, Nullable<Boolean>, Boolean)
Obsolete.

Configures whether the index is clustered when targeting SQL Server.

ForSqlServerIsClustered(IndexBuilder, Boolean)
Obsolete.

Configures whether the index is clustered when targeting SQL Server.

ForSqlServerIsClustered<TEntity>(IndexBuilder<TEntity>, Boolean)
Obsolete.

Configures whether the index is clustered when targeting SQL Server.

ForSqlServerIsCreatedOnline(IConventionIndexBuilder, Nullable<Boolean>, Boolean)
Obsolete.

Configures whether the index is created with online option when targeting SQL Server.

ForSqlServerIsCreatedOnline(IndexBuilder, Boolean)
Obsolete.

Configures whether the index is created with online option when targeting SQL Server.

ForSqlServerIsCreatedOnline<TEntity>(IndexBuilder<TEntity>, Boolean)
Obsolete.

Configures whether the index is created with online option when targeting SQL Server.

HasFillFactor(IConventionIndexBuilder, Nullable<Int32>, Boolean)

Configures whether the index is created with fill factor option when targeting SQL Server.

HasFillFactor(IndexBuilder, Int32)

Configures whether the index is created with fill factor option when targeting SQL Server.

HasFillFactor<TEntity>(IndexBuilder<TEntity>, Int32)

Configures whether the index is created with fill factor option when targeting SQL Server.

IncludeProperties(IConventionIndexBuilder, IReadOnlyList<String>, Boolean)

Configures index include properties when targeting SQL Server.

IncludeProperties(IndexBuilder, String[])

Configures index include properties when targeting SQL Server.

IncludeProperties<TEntity>(IndexBuilder<TEntity>, Expression<Func<TEntity,Object>>)

Configures index include properties when targeting SQL Server.

IncludeProperties<TEntity>(IndexBuilder<TEntity>, String[])

Configures index include properties when targeting SQL Server.

IsClustered(IConventionIndexBuilder, Nullable<Boolean>, Boolean)

Configures whether the index is clustered when targeting SQL Server.

IsClustered(IndexBuilder, Boolean)

Configures whether the index is clustered when targeting SQL Server.

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

Configures whether the index is clustered when targeting SQL Server.

IsCreatedOnline(IConventionIndexBuilder, Nullable<Boolean>, Boolean)

Configures whether the index is created with online option when targeting SQL Server.

IsCreatedOnline(IndexBuilder, Boolean)

Configures whether the index is created with online option when targeting SQL Server.

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

Configures whether the index is created with online 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(IndexBuilder, 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.

UseDataCompression(IConventionIndexBuilder, Nullable<DataCompressionType>, Boolean)

Configures whether the index is created with data compression option when targeting SQL Server.

UseDataCompression(IndexBuilder, DataCompressionType)

Configures whether the index is created with data compression option when targeting SQL Server.

UseDataCompression<TEntity>(IndexBuilder<TEntity>, DataCompressionType)

Configures whether the index is created with data compression option when targeting SQL Server.

Applies to