RelationalPropertyBuilderExtensions.HasDefaultValueSql 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
| HasDefaultValueSql(IConventionPropertyBuilder, String, Boolean) |
Configures the default value expression for the column that the property maps to when targeting a relational database. |
| HasDefaultValueSql(PropertyBuilder, String) |
Configures the default value expression for the column that the property maps to when targeting a relational database. |
| HasDefaultValueSql(PropertyBuilder) |
Configures the default value expression for the column that the property maps to when targeting a relational database. |
| HasDefaultValueSql<TProperty>(PropertyBuilder<TProperty>) |
Configures the default value expression for the column that the property maps to when targeting a relational database. |
| HasDefaultValueSql<TProperty>(PropertyBuilder<TProperty>, String) |
Configures the default value expression for the column that the property maps to when targeting a relational database. |
HasDefaultValueSql(IConventionPropertyBuilder, String, Boolean)
Configures the default value expression for the column that the property maps to when targeting a relational database.
public static Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionPropertyBuilder HasDefaultValueSql (this Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionPropertyBuilder propertyBuilder, string sql, bool fromDataAnnotation = false);public static Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionPropertyBuilder? HasDefaultValueSql (this Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionPropertyBuilder propertyBuilder, string? sql, bool fromDataAnnotation = false);static member HasDefaultValueSql : Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionPropertyBuilder * string * bool -> Microsoft.EntityFrameworkCore.Metadata.Builders.IConventionPropertyBuilder<Extension()>
Public Function HasDefaultValueSql (propertyBuilder As IConventionPropertyBuilder, sql As String, Optional fromDataAnnotation As Boolean = false) As IConventionPropertyBuilderParameters
- propertyBuilder
- IConventionPropertyBuilder
The builder for the property being configured.
- sql
- String
The SQL expression for the default value of the column.
- 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 Database default values for more information and examples.
Applies to
HasDefaultValueSql(PropertyBuilder, String)
Configures the default value expression for the column that the property maps to when targeting a relational database.
public static Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder HasDefaultValueSql (this Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder propertyBuilder, string sql);public static Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder HasDefaultValueSql (this Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder propertyBuilder, string? sql);static member HasDefaultValueSql : Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder * string -> Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<Extension()>
Public Function HasDefaultValueSql (propertyBuilder As PropertyBuilder, sql As String) As PropertyBuilderParameters
- propertyBuilder
- PropertyBuilder
The builder for the property being configured.
- sql
- String
The SQL expression for the default value of the column.
Returns
The same builder instance so that multiple calls can be chained.
Remarks
See Database default values for more information and examples.
Applies to
HasDefaultValueSql(PropertyBuilder)
Configures the default value expression for the column that the property maps to when targeting a relational database.
public static Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder HasDefaultValueSql (this Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder propertyBuilder);static member HasDefaultValueSql : Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder -> Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<Extension()>
Public Function HasDefaultValueSql (propertyBuilder As PropertyBuilder) As PropertyBuilderParameters
- propertyBuilder
- PropertyBuilder
The builder for the property being configured.
Returns
The same builder instance so that multiple calls can be chained.
Remarks
When called with no argument, this method tells EF that a column has a default value constraint of some sort without needing to specify exactly what it is. This can be useful when mapping EF to an existing database.
See Database default values for more information and examples.
Applies to
HasDefaultValueSql<TProperty>(PropertyBuilder<TProperty>)
Configures the default value expression for the column that the property maps to when targeting a relational database.
public static Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<TProperty> HasDefaultValueSql<TProperty> (this Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<TProperty> propertyBuilder);static member HasDefaultValueSql : Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<'Property> -> Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<'Property><Extension()>
Public Function HasDefaultValueSql(Of TProperty) (propertyBuilder As PropertyBuilder(Of TProperty)) As PropertyBuilder(Of TProperty)Type Parameters
- TProperty
The type of the property being configured.
Parameters
- propertyBuilder
- PropertyBuilder<TProperty>
The builder for the property being configured.
Returns
The same builder instance so that multiple calls can be chained.
Remarks
When called with no argument, this method tells EF that a column has a default value constraint of some sort without needing to specify exactly what it is. This can be useful when mapping EF to an existing database.
See Database default values for more information and examples.
Applies to
HasDefaultValueSql<TProperty>(PropertyBuilder<TProperty>, String)
Configures the default value expression for the column that the property maps to when targeting a relational database.
public static Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<TProperty> HasDefaultValueSql<TProperty> (this Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<TProperty> propertyBuilder, string sql);public static Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<TProperty> HasDefaultValueSql<TProperty> (this Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<TProperty> propertyBuilder, string? sql);static member HasDefaultValueSql : Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<'Property> * string -> Microsoft.EntityFrameworkCore.Metadata.Builders.PropertyBuilder<'Property><Extension()>
Public Function HasDefaultValueSql(Of TProperty) (propertyBuilder As PropertyBuilder(Of TProperty), sql As String) As PropertyBuilder(Of TProperty)Type Parameters
- TProperty
The type of the property being configured.
Parameters
- propertyBuilder
- PropertyBuilder<TProperty>
The builder for the property being configured.
- sql
- String
The SQL expression for the default value of the column.
Returns
The same builder instance so that multiple calls can be chained.
Remarks
See Database default values 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