Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

RelationalPropertyBuilderExtensions.HasDefaultValueSql Method

Definition

Namespace:: Microsoft.EntityFrameworkCore

Assembly:: Microsoft.EntityFrameworkCore.Relational.dll

Package:: Microsoft.EntityFrameworkCore.Relational v10.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v3.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v3.1.0

Package:: Microsoft.EntityFrameworkCore.Relational v5.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v6.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v7.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v8.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v9.0.0

Package:: Microsoft.EntityFrameworkCore.Relational v1.0.6

Package:: Microsoft.EntityFrameworkCore.Relational v1.1.6

Package:: Microsoft.EntityFrameworkCore.Relational v2.0.3

Package:: Microsoft.EntityFrameworkCore.Relational v2.1.11

Package:: Microsoft.EntityFrameworkCore.Relational v2.2.6

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

Name	Description
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)

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

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 IConventionPropertyBuilder

Parameters

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

IConventionPropertyBuilder

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)

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

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 PropertyBuilder

Parameters

propertyBuilder: PropertyBuilder

The builder for the property being configured.

sql: String

The SQL expression for the default value of the column.

Returns

PropertyBuilder

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)

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

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 PropertyBuilder

Parameters

propertyBuilder: PropertyBuilder

The builder for the property being configured.

Returns

PropertyBuilder

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>)

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

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

PropertyBuilder<TProperty>

The same builder instance so that multiple calls can be chained.

Remarks

See Database default values for more information and examples.

Applies to

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

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

Source:: RelationalPropertyBuilderExtensions.cs

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

PropertyBuilder<TProperty>

The same builder instance so that multiple calls can be chained.

Remarks

See Database default values for more information and examples.

Applies to

Feedback

Was this page helpful?

URL: https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationalpropertybuilderextensions.hasdefaultvaluesql?view=efcore-10.0