SqlServerModelBuilderExtensions Class

Definition

SQL Server specific extension methods for ModelBuilder.

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

Remarks

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

Methods

CanSetDatabaseMaxSize(IConventionModelBuilder, String, Boolean)

Returns a value indicating whether the given value can be set as the maximum size of the database.

CanSetHiLoSequence(IConventionModelBuilder, String, String, Boolean)

Returns a value indicating whether the given name and schema can be set for the hi-lo sequence.

CanSetIdentityColumnIncrement(IConventionModelBuilder, Nullable<Int32>, Boolean)

Returns a value indicating whether the given value can be set as the default increment for SQL Server IDENTITY.

CanSetIdentityColumnSeed(IConventionModelBuilder, Nullable<Int32>, Boolean)

Returns a value indicating whether the given value can be set as the default seed for SQL Server IDENTITY.

CanSetIdentityColumnSeed(IConventionModelBuilder, Nullable<Int64>, Boolean)

Returns a value indicating whether the given value can be set as the default seed for SQL Server IDENTITY.

CanSetPerformanceLevelSql(IConventionModelBuilder, String, Boolean)

Returns a value indicating whether the given value can be set as the performance level of the database.

CanSetServiceTierSql(IConventionModelBuilder, String, Boolean)

Returns a value indicating whether the given value can be set as the service tier of the database.

CanSetValueGenerationStrategy(IConventionModelBuilder, Nullable<SqlServerValueGenerationStrategy>, Boolean)

Returns a value indicating whether the given value can be set as the default value generation strategy.

ForSqlServerHasHiLoSequence(IConventionModelBuilder, String, String, Boolean)
Obsolete.

Configures the database sequence used for the hi-lo pattern to generate values for key properties marked as OnAdd, when targeting SQL Server.

ForSqlServerHasIdentityIncrement(IConventionModelBuilder, Nullable<Int32>, Boolean)
Obsolete.

Configures the default increment for SQL Server IDENTITY.

ForSqlServerHasIdentitySeed(IConventionModelBuilder, Nullable<Int32>, Boolean)
Obsolete.

Configures the default seed for SQL Server IDENTITY.

ForSqlServerHasSequence(ModelBuilder, String, Action<RelationalSequenceBuilder>)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence(ModelBuilder, String, String)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence(ModelBuilder, String, String, Action<RelationalSequenceBuilder>)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence(ModelBuilder, Type, String, Action<RelationalSequenceBuilder>)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence(ModelBuilder, Type, String, String)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence(ModelBuilder, Type, String, String, Action<RelationalSequenceBuilder>)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence<T>(ModelBuilder, String, Action<RelationalSequenceBuilder>)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence<T>(ModelBuilder, String, String)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasSequence<T>(ModelBuilder, String, String, Action<RelationalSequenceBuilder>)

Configures a database sequence when targeting SQL Server.

ForSqlServerHasValueGenerationStrategy(IConventionModelBuilder, Nullable<SqlServerValueGenerationStrategy>, Boolean)
Obsolete.

Configures the default value generation strategy for key properties marked as OnAdd, when targeting SQL Server.

ForSqlServerUseIdentityColumns(ModelBuilder)

Configures the model to use the SQL Server IDENTITY feature to generate values for key properties marked as OnAdd, when targeting SQL Server. This is the default behavior when targeting SQL Server.

ForSqlServerUseIdentityColumns(ModelBuilder, Int32, Int32)
Obsolete.

Configures the model to use the SQL Server IDENTITY feature to generate values for key properties marked as OnAdd, when targeting SQL Server. This is the default behavior when targeting SQL Server.

ForSqlServerUseSequenceHiLo(ModelBuilder, String, String)
Obsolete.

Configures the model to use a sequence-based hi-lo pattern to generate values for key properties marked as OnAdd, when targeting SQL Server.

HasDatabaseMaxSize(IConventionModelBuilder, String, Boolean)

Attempts to configure the maximum size for Azure SQL Database.

HasDatabaseMaxSize(ModelBuilder, String)

Configures the maximum size for Azure SQL Database.

HasHiLoSequence(IConventionModelBuilder, String, String, Boolean)

Configures the database sequence used for the hi-lo pattern to generate values for key properties marked as OnAdd, when targeting SQL Server.

HasIdentityColumnIncrement(IConventionModelBuilder, Nullable<Int32>, Boolean)

Configures the default increment for SQL Server IDENTITY.

HasIdentityColumnSeed(IConventionModelBuilder, Nullable<Int32>, Boolean)

Configures the default seed for SQL Server IDENTITY.

HasIdentityColumnSeed(IConventionModelBuilder, Nullable<Int64>, Boolean)

Configures the default seed for SQL Server IDENTITY.

HasPerformanceLevel(ModelBuilder, String)

Configures the performance level (SERVICE_OBJECTIVE) for Azure SQL Database as a string literal.

HasPerformanceLevelSql(IConventionModelBuilder, String, Boolean)

Attempts to configure the performance level (SERVICE_OBJECTIVE) for Azure SQL Database.

HasPerformanceLevelSql(ModelBuilder, String)

Configures the performance level (SERVICE_OBJECTIVE) for Azure SQL Database as a SQL expression.

HasServiceTier(ModelBuilder, String)

Configures the service tier (EDITION) for Azure SQL Database as a string literal.

HasServiceTierSql(IConventionModelBuilder, String, Boolean)

Attempts to configure the service tier (EDITION) for Azure SQL Database.

HasServiceTierSql(ModelBuilder, String)

Configures the service tier (EDITION) for Azure SQL Database as a SQL expression.

HasValueGenerationStrategy(IConventionModelBuilder, Nullable<SqlServerValueGenerationStrategy>, Boolean)

Configures the default value generation strategy for key properties marked as OnAdd, when targeting SQL Server.

UseHiLo(ModelBuilder, String, String)

Configures the model to use a sequence-based hi-lo pattern to generate values for key properties marked as OnAdd, when targeting SQL Server.

UseIdentityColumns(ModelBuilder, Int32, Int32)

Configures the model to use the SQL Server IDENTITY feature to generate values for key properties marked as OnAdd, when targeting SQL Server. This is the default behavior when targeting SQL Server.

UseIdentityColumns(ModelBuilder, Int64, Int32)

Configures the model to use the SQL Server IDENTITY feature to generate values for key properties marked as OnAdd, when targeting SQL Server. This is the default behavior when targeting SQL Server.

UseKeySequences(ModelBuilder, String, String)

Configures the model to use a sequence per hierarchy to generate values for key properties marked as OnAdd, when targeting SQL Server.

Applies to