SqliteMigrationsSqlGenerator.ColumnDefinition Method

Reference

Definition

Namespace:: Microsoft.EntityFrameworkCore.Migrations

Assembly:: Microsoft.EntityFrameworkCore.Sqlite.dll

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v2.1.11

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v2.2.6

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v3.0.0

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v3.1.0

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v5.0.0

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v6.0.0

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v7.0.0

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v8.0.0

Package:: Microsoft.EntityFrameworkCore.Sqlite v1.0.6

Package:: Microsoft.EntityFrameworkCore.Sqlite v1.1.6

Package:: Microsoft.EntityFrameworkCore.Sqlite.Core v2.0.3

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

ColumnDefinition(AddColumnOperation, IModel, MigrationCommandListBuilder)	Generates a SQL fragment for a column definition in an AddColumnOperation.
ColumnDefinition(String, String, String, ColumnOperation, IModel, MigrationCommandListBuilder)	Generates a SQL fragment for a column definition for the given column metadata.
ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)	Generates a SQL fragment for a column definition for the given column metadata.
ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Nullable<Boolean>, Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)	Generates a SQL fragment for a column definition for the given column metadata.

ColumnDefinition(AddColumnOperation, IModel, MigrationCommandListBuilder)

Generates a SQL fragment for a column definition in an AddColumnOperation.

protected override void ColumnDefinition (Microsoft.EntityFrameworkCore.Migrations.Operations.AddColumnOperation operation, Microsoft.EntityFrameworkCore.Metadata.IModel model, Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder builder);

override this.ColumnDefinition : Microsoft.EntityFrameworkCore.Migrations.Operations.AddColumnOperation * Microsoft.EntityFrameworkCore.Metadata.IModel * Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder -> unit

Protected Overrides Sub ColumnDefinition (operation As AddColumnOperation, model As IModel, builder As MigrationCommandListBuilder)

Parameters

operation: AddColumnOperation

The operation.

model: IModel

The target model which may be null if the operations exist without a model.

builder: MigrationCommandListBuilder

The command builder to use to add the SQL fragment.

Applies to

ColumnDefinition(String, String, String, ColumnOperation, IModel, MigrationCommandListBuilder)

Generates a SQL fragment for a column definition for the given column metadata.

protected override void ColumnDefinition (string schema, string table, string name, Microsoft.EntityFrameworkCore.Migrations.Operations.ColumnOperation operation, Microsoft.EntityFrameworkCore.Metadata.IModel model, Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder builder);

protected override void ColumnDefinition (string? schema, string table, string name, Microsoft.EntityFrameworkCore.Migrations.Operations.ColumnOperation operation, Microsoft.EntityFrameworkCore.Metadata.IModel? model, Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder builder);

override this.ColumnDefinition : string * string * string * Microsoft.EntityFrameworkCore.Migrations.Operations.ColumnOperation * Microsoft.EntityFrameworkCore.Metadata.IModel * Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder -> unit

Protected Overrides Sub ColumnDefinition (schema As String, table As String, name As String, operation As ColumnOperation, model As IModel, builder As MigrationCommandListBuilder)

Parameters

schema: String

The schema that contains the table, or null to use the default schema.

table: String

The table that contains the column.

name: String

The column name.

operation: ColumnOperation

The column metadata.

model: IModel

The target model which may be null if the operations exist without a model.

builder: MigrationCommandListBuilder

The command builder to use to add the SQL fragment.

Applies to

ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)

Generates a SQL fragment for a column definition for the given column metadata.

protected override void ColumnDefinition (string schema, string table, string name, Type clrType, string type, bool? unicode, int? maxLength, bool rowVersion, bool nullable, object defaultValue, string defaultValueSql, string computedColumnSql, Microsoft.EntityFrameworkCore.Infrastructure.IAnnotatable annotatable, Microsoft.EntityFrameworkCore.Metadata.IModel model, Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder builder);

override this.ColumnDefinition : string * string * string * Type * string * Nullable<bool> * Nullable<int> * bool * bool * obj * string * string * Microsoft.EntityFrameworkCore.Infrastructure.IAnnotatable * Microsoft.EntityFrameworkCore.Metadata.IModel * Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder -> unit

Protected Overrides Sub ColumnDefinition (schema As String, table As String, name As String, clrType As Type, type As String, unicode As Nullable(Of Boolean), maxLength As Nullable(Of Integer), rowVersion As Boolean, nullable As Boolean, defaultValue As Object, defaultValueSql As String, computedColumnSql As String, annotatable As IAnnotatable, model As IModel, builder As MigrationCommandListBuilder)

Parameters

schema: String

The schema that contains the table, or null to use the default schema.

table: String

The table that contains the column.

name: String

The column name.

clrType: Type

The CLR Type that the column is mapped to.

type: String

The database/store type for the column, or null if none has been specified.

unicode: Nullable<Boolean>

Indicates whether or not the column can contain Unicode data, or null if this is not applicable or not specified.

maxLength: Nullable<Int32>

The maximum amount of data that the column can contain, or null if this is not applicable or not specified.

rowVersion: Boolean

Indicates whether or not this column is an automatic concurrency token, such as a SQL Server timestamp/rowversion.

nullable: Boolean

Indicates whether or not the column can store NULL values.

defaultValue: Object

The default value for the column.

defaultValueSql: String

The SQL expression to use for the column's default constraint.

computedColumnSql: String

The SQL expression to use to compute the column value.

annotatable: IAnnotatable

The MigrationOperation to use to find any custom annotations.

model: IModel

The target model which may be null if the operations exist without a model.

builder: MigrationCommandListBuilder

The command builder to use to add the SQL fragment.

Applies to

ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Nullable<Boolean>, Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)

Generates a SQL fragment for a column definition for the given column metadata.

protected override void ColumnDefinition (string schema, string table, string name, Type clrType, string type, bool? unicode, int? maxLength, bool? fixedLength, bool rowVersion, bool nullable, object defaultValue, string defaultValueSql, string computedColumnSql, Microsoft.EntityFrameworkCore.Infrastructure.IAnnotatable annotatable, Microsoft.EntityFrameworkCore.Metadata.IModel model, Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder builder);

override this.ColumnDefinition : string * string * string * Type * string * Nullable<bool> * Nullable<int> * Nullable<bool> * bool * bool * obj * string * string * Microsoft.EntityFrameworkCore.Infrastructure.IAnnotatable * Microsoft.EntityFrameworkCore.Metadata.IModel * Microsoft.EntityFrameworkCore.Migrations.MigrationCommandListBuilder -> unit

Protected Overrides Sub ColumnDefinition (schema As String, table As String, name As String, clrType As Type, type As String, unicode As Nullable(Of Boolean), maxLength As Nullable(Of Integer), fixedLength As Nullable(Of Boolean), rowVersion As Boolean, nullable As Boolean, defaultValue As Object, defaultValueSql As String, computedColumnSql As String, annotatable As IAnnotatable, model As IModel, builder As MigrationCommandListBuilder)

Parameters

schema: String

The schema that contains the table, or null to use the default schema.

table: String

The table that contains the column.

name: String

The column name.

clrType: Type

The CLR Type that the column is mapped to.

type: String

The database/store type for the column, or null if none has been specified.

unicode: Nullable<Boolean>

Indicates whether or not the column can contain Unicode data, or null if this is not applicable or not specified.

maxLength: Nullable<Int32>

The maximum amount of data that the column can contain, or null if this is not applicable or not specified.

fixedLength: Nullable<Boolean>

Indicates whether or not the column is constrained to fixed-length data.

rowVersion: Boolean

Indicates whether or not this column is an automatic concurrency token, such as a SQL Server timestamp/rowversion.

nullable: Boolean

Indicates whether or not the column can store NULL values.

defaultValue: Object

The default value for the column.

defaultValueSql: String

The SQL expression to use for the column's default constraint.

computedColumnSql: String

The SQL expression to use to compute the column value.

annotatable: IAnnotatable

The MigrationOperation to use to find any custom annotations.

model: IModel

The target model which may be null if the operations exist without a model.

builder: MigrationCommandListBuilder

The command builder to use to add the SQL fragment.

Applies to

SqliteMigrationsSqlGenerator.ColumnDefinition Method

Definition

Overloads

ColumnDefinition(AddColumnOperation, IModel, MigrationCommandListBuilder)

Parameters

Applies to

ColumnDefinition(String, String, String, ColumnOperation, IModel, MigrationCommandListBuilder)

Parameters

Applies to

ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)

Parameters

Applies to

ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Nullable<Boolean>, Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)

Parameters

Applies to

Feedback

Additional resources