SqlServerIndexExtensions Class

Definition

Index extension methods for SQL Server-specific metadata.

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

Remarks

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

Methods

GetDataCompression(IReadOnlyIndex)

Returns the data compression that the index uses.

GetDataCompression(IReadOnlyIndex, StoreObjectIdentifier)

Returns the data compression that the index uses.

GetDataCompressionConfigurationSource(IConventionIndex)

Returns the ConfigurationSource for the data compression the index uses.

GetFillFactor(IIndex)

Returns a value indicating whether the index uses the fill factor.

GetFillFactor(IReadOnlyIndex)

Returns the fill factor that the index uses.

GetFillFactor(IReadOnlyIndex, StoreObjectIdentifier)

Returns the fill factor that the index uses.

GetFillFactorConfigurationSource(IConventionIndex)

Returns the ConfigurationSource for whether the index uses the fill factor.

GetIncludeProperties(IIndex)

Returns included property names, or null if they have not been specified.

GetIncludeProperties(IReadOnlyIndex)

Returns included property names, or null if they have not been specified.

GetIncludeProperties(IReadOnlyIndex, StoreObjectIdentifier)

Returns included property names, or null if they have not been specified.

GetIncludePropertiesConfigurationSource(IConventionIndex)

Returns the ConfigurationSource for the included property names.

GetIsClusteredConfigurationSource(IConventionIndex)

Returns the ConfigurationSource for whether the index is clustered.

GetIsCreatedOnlineConfigurationSource(IConventionIndex)

Returns the ConfigurationSource for whether the index is online.

GetSortInTempDb(IReadOnlyIndex)

Returns a value indicating whether the index is sorted in tempdb.

GetSortInTempDb(IReadOnlyIndex, StoreObjectIdentifier)

Returns a value indicating whether the index is sorted in tempdb.

GetSortInTempDbConfigurationSource(IConventionIndex)

Returns the ConfigurationSource for whether the index is sorted in tempdb.

IsClustered(IIndex)

Returns a value indicating whether the index is clustered.

IsClustered(IIndex, StoreObjectIdentifier)

Returns a value indicating whether the index is clustered.

IsClustered(IReadOnlyIndex)

Returns a value indicating whether the index is clustered.

IsClustered(IReadOnlyIndex, StoreObjectIdentifier)

Returns a value indicating whether the index is clustered.

IsCreatedOnline(IIndex)

Returns a value indicating whether the index is online.

IsCreatedOnline(IReadOnlyIndex)

Returns a value indicating whether the index is online.

IsCreatedOnline(IReadOnlyIndex, StoreObjectIdentifier)

Returns a value indicating whether the index is online.

SetDataCompression(IConventionIndex, Nullable<DataCompressionType>, Boolean)

Sets a value indicating the data compression the index uses.

SetDataCompression(IMutableIndex, Nullable<DataCompressionType>)

Sets a value indicating the data compression the index uses.

SetFillFactor(IConventionIndex, Nullable<Int32>, Boolean)

Defines a value indicating whether the index uses the fill factor.

SetFillFactor(IMutableIndex, Nullable<Int32>)

Sets a value indicating whether the index uses the fill factor.

SetIncludeProperties(IConventionIndex, IReadOnlyList<String>, Boolean)

Sets included property names.

SetIncludeProperties(IMutableIndex, IReadOnlyList<String>)

Sets included property names.

SetIsClustered(IConventionIndex, Nullable<Boolean>, Boolean)

Sets a value indicating whether the index is clustered.

SetIsClustered(IMutableIndex, Nullable<Boolean>)

Sets a value indicating whether the index is clustered.

SetIsCreatedOnline(IConventionIndex, Nullable<Boolean>, Boolean)

Sets a value indicating whether the index is online.

SetIsCreatedOnline(IMutableIndex, Nullable<Boolean>)

Sets a value indicating whether the index is online.

SetSortInTempDb(IConventionIndex, Nullable<Boolean>, Boolean)

Sets a value indicating whether the index is sorted in tempdb.

SetSortInTempDb(IMutableIndex, Nullable<Boolean>)

Sets a value indicating whether the index is sorted in tempdb.

Applies to