SqlServerPropertyBuilderExtensions Class

Definition

SQL Server specific extension methods for PropertyBuilder.

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

Remarks

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

Methods

CanSetHiLoSequence(IConventionPropertyBuilder, String, String, Boolean)

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

CanSetIdentityColumnIncrement(IConventionPropertyBuilder, Nullable<Int32>, Boolean)

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

CanSetIdentityColumnIncrement(IConventionPropertyBuilder, Nullable<Int32>, StoreObjectIdentifier, Boolean)

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

CanSetIdentityColumnSeed(IConventionPropertyBuilder, Nullable<Int32>, Boolean)

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

CanSetIdentityColumnSeed(IConventionPropertyBuilder, Nullable<Int64>, Boolean)

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

CanSetIdentityColumnSeed(IConventionPropertyBuilder, Nullable<Int64>, StoreObjectIdentifier, Boolean)

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

CanSetIsSparse(IConventionPropertyBuilder, Nullable<Boolean>, Boolean)

Returns a value indicating whether the property's column can be configured as sparse when targeting SQL Server.

CanSetSequence(IConventionPropertyBuilder, String, String, Boolean)

Returns a value indicating whether the given name and schema can be set for the key value generation sequence.

CanSetValueGenerationStrategy(IConventionPropertyBuilder, Nullable<SqlServerValueGenerationStrategy>, Boolean)

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

CanSetValueGenerationStrategy(IConventionPropertyBuilder, Nullable<SqlServerValueGenerationStrategy>, StoreObjectIdentifier, Boolean)

Returns a value indicating whether the given value can be set as the value generation strategy for a particular table.

ForSqlServerHasColumnName(PropertyBuilder, String)

Configures the column that the property maps to when targeting SQL Server.

ForSqlServerHasColumnName<TProperty>(PropertyBuilder<TProperty>, String)

Configures the column that the property maps to when targeting SQL Server.

ForSqlServerHasColumnType(PropertyBuilder, String)

Configures the data type of the column that the property maps to when targeting SQL Server. This should be the complete type name, including precision, scale, length, etc.

ForSqlServerHasColumnType<TProperty>(PropertyBuilder<TProperty>, String)

Configures the data type of the column that the property maps to when targeting SQL Server. This should be the complete type name, including precision, scale, length, etc.

ForSqlServerHasComputedColumnSql(PropertyBuilder, String)

Configures the property to map to a computed column when targeting SQL Server.

ForSqlServerHasComputedColumnSql<TProperty>(PropertyBuilder<TProperty>, String)

Configures the property to map to a computed column when targeting SQL Server.

ForSqlServerHasDefaultValue(PropertyBuilder, Object)

Configures the default value for the column that the property maps to when targeting SQL Server.

ForSqlServerHasDefaultValue<TProperty>(PropertyBuilder<TProperty>, Object)

Configures the default value for the column that the property maps to when targeting SQL Server.

ForSqlServerHasDefaultValueSql(PropertyBuilder, String)

Configures the default value expression for the column that the property maps to when targeting SQL Server.

ForSqlServerHasDefaultValueSql<TProperty>(PropertyBuilder<TProperty>, String)

Configures the default value expression for the column that the property maps to when targeting SQL Server.

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

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

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

Configures the increment for SQL Server IDENTITY.

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

Configures the seed for SQL Server IDENTITY.

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

Configures the value generation strategy for the key property, when targeting SQL Server.

ForSqlServerUseSequenceHiLo(PropertyBuilder, String, String)
Obsolete.

Configures the key property to use a sequence-based hi-lo pattern to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

ForSqlServerUseSequenceHiLo<TProperty>(PropertyBuilder<TProperty>, String, String)
Obsolete.

Configures the key property to use a sequence-based hi-lo pattern to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

HasHiLoSequence(IConventionPropertyBuilder, String, String, Boolean)

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

HasIdentityColumnIncrement(IConventionPropertyBuilder, Nullable<Int32>, Boolean)

Configures the increment for SQL Server IDENTITY.

HasIdentityColumnIncrement(IConventionPropertyBuilder, Nullable<Int32>, StoreObjectIdentifier, Boolean)

Configures the increment for SQL Server IDENTITY for a particular table.

HasIdentityColumnSeed(IConventionPropertyBuilder, Nullable<Int32>, Boolean)

Configures the seed for SQL Server IDENTITY.

HasIdentityColumnSeed(IConventionPropertyBuilder, Nullable<Int64>, Boolean)

Configures the seed for SQL Server IDENTITY.

HasIdentityColumnSeed(IConventionPropertyBuilder, Nullable<Int64>, StoreObjectIdentifier, Boolean)

Configures the seed for SQL Server IDENTITY for a particular table.

HasSequence(IConventionPropertyBuilder, String, String, Boolean)

Configures the database sequence used for the key value generation pattern to generate values for the key property, when targeting SQL Server.

HasValueGenerationStrategy(IConventionPropertyBuilder, Nullable<SqlServerValueGenerationStrategy>, Boolean)

Configures the value generation strategy for the key property, when targeting SQL Server.

HasValueGenerationStrategy(IConventionPropertyBuilder, Nullable<SqlServerValueGenerationStrategy>, StoreObjectIdentifier, Boolean)

Configures the value generation strategy for the key property, when targeting SQL Server for a particular table.

IsSparse(IConventionPropertyBuilder, Nullable<Boolean>, Boolean)

Configures whether the property's column is created as sparse when targeting SQL Server.

IsSparse(PropertyBuilder, Boolean)

Configures whether the property's column is created as sparse when targeting SQL Server.

IsSparse<TProperty>(PropertyBuilder<TProperty>, Boolean)

Configures whether the property's column is created as sparse when targeting SQL Server.

UseHiLo(PropertyBuilder, String, String)

Configures the key property to use a sequence-based hi-lo pattern to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseHiLo<TProperty>(PropertyBuilder<TProperty>, String, String)

Configures the key property to use a sequence-based hi-lo pattern to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseIdentityColumn(ColumnBuilder, Int64, Int32)

Configures the key column to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseIdentityColumn(PropertyBuilder, Int32, Int32)

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseIdentityColumn(PropertyBuilder, Int64, Int32)

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseIdentityColumn<TProperty>(ColumnBuilder<TProperty>, Int64, Int32)

Configures the key column to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseIdentityColumn<TProperty>(PropertyBuilder<TProperty>, Int32, Int32)

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseIdentityColumn<TProperty>(PropertyBuilder<TProperty>, Int64, Int32)

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseSequence(PropertyBuilder, String, String)

Configures the key property to use a sequence-based key value generation pattern to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseSequence<TProperty>(PropertyBuilder<TProperty>, String, String)

Configures the key property to use a sequence-based key value generation pattern to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseSqlServerIdentityColumn(PropertyBuilder)

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseSqlServerIdentityColumn(PropertyBuilder, Int32, Int32)
Obsolete.

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseSqlServerIdentityColumn<TProperty>(PropertyBuilder<TProperty>)

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

UseSqlServerIdentityColumn<TProperty>(PropertyBuilder<TProperty>, Int32, Int32)
Obsolete.

Configures the key property to use the SQL Server IDENTITY feature to generate values for new entities, when targeting SQL Server. This method sets the property to be OnAdd.

Applies to