MigrationBuilder.InsertData Method

Definition

Namespace:

Microsoft.EntityFrameworkCore.Migrations

Assembly:

Microsoft.EntityFrameworkCore.Relational.dll

Package:

Microsoft.EntityFrameworkCore.Relational v8.0.0

Overloads

InsertData(String, String[], String[], Object[,], String)	Builds an InsertDataOperation to insert multiple rows of seed data values for multiple columns.
InsertData(String, String[], String[], Object[], String)	Builds an InsertDataOperation to insert a single row of seed data values.
InsertData(String, String, String, Object, String)	Builds an InsertDataOperation to insert a single seed data value for a single column.
InsertData(String, String, String, Object[], String)	Builds an InsertDataOperation to insert multiple rows of seed data values for a single column.
InsertData(String, String[], Object[,], String)	Builds an InsertDataOperation to insert multiple rows of seed data values for multiple columns.
InsertData(String, String, Object[], String)	Builds an InsertDataOperation to insert multiple rows of seed data values for a single column.
InsertData(String, String, Object, String)	Builds an InsertDataOperation to insert a single seed data value for a single column.
InsertData(String, String[], Object[], String)	Builds an InsertDataOperation to insert a single row of seed data values.

InsertData(String, String[], String[], Object[,], String)

Builds an InsertDataOperation to insert multiple rows of seed data values for multiple columns.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string[] columns, string[] columnTypes, object?[,] values, string? schema = default);

abstract member InsertData : string * string[] * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string[] * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, columns As String(), columnTypes As String(), values As Object(,), Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

columns

String[]

The names of the columns into which the data will be inserted.

columnTypes

String[]

A list of store types for the columns into which data will be inserted.

values

Object[,]

The values to insert where each element of the outer array represents a row, and each inner array contains values for each of the columns in 'columns'.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.

InsertData(String, String[], String[], Object[], String)

Builds an InsertDataOperation to insert a single row of seed data values.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string[] columns, string[] columnTypes, object?[] values, string? schema = default);

abstract member InsertData : string * string[] * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string[] * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, columns As String(), columnTypes As String(), values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

columns

String[]

The names of the columns into which the data will be inserted.

columnTypes

String[]

A list of store types for the columns into which data will be inserted.

values

Object[]

The values to insert, one value for each column in 'columns'.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.

InsertData(String, String, String, Object, String)

Builds an InsertDataOperation to insert a single seed data value for a single column.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string column, string columnType, object? value, string? schema = default);

abstract member InsertData : string * string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, column As String, columnType As String, value As Object, Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

column

String

The name of the column into which the data will be inserted.

columnType

String

The store type for the column into which data will be inserted.

value

Object

The value to insert.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.

InsertData(String, String, String, Object[], String)

Builds an InsertDataOperation to insert multiple rows of seed data values for a single column.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string column, string columnType, object[] values, string? schema = default);

abstract member InsertData : string * string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, column As String, columnType As String, values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

column

String

The name of the column into which the data will be inserted.

columnType

String

The store type for the column into which data will be inserted.

values

Object[]

The values to insert, one value for each row.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.

InsertData(String, String[], Object[,], String)

Builds an InsertDataOperation to insert multiple rows of seed data values for multiple columns.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string[] columns, object?[,] values, string? schema = default);

abstract member InsertData : string * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, columns As String(), values As Object(,), Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

columns

String[]

The names of the columns into which the data will be inserted.

values

Object[,]

The values to insert where each element of the outer array represents a row, and each inner array contains values for each of the columns in 'columns'.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.

InsertData(String, String, Object[], String)

Builds an InsertDataOperation to insert multiple rows of seed data values for a single column.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string column, object[] values, string? schema = default);

abstract member InsertData : string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, column As String, values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

column

String

The name of the column into which the data will be inserted.

values

Object[]

The values to insert, one value for each row.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.

InsertData(String, String, Object, String)

Builds an InsertDataOperation to insert a single seed data value for a single column.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string column, object? value, string? schema = default);

abstract member InsertData : string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, column As String, value As Object, Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

column

String

The name of the column into which the data will be inserted.

value

Object

The value to insert.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.

InsertData(String, String[], Object[], String)

Builds an InsertDataOperation to insert a single row of seed data values.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation> InsertData (string table, string[] columns, object?[] values, string? schema = default);

abstract member InsertData : string * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>
override this.InsertData : string * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.InsertDataOperation>

Public Overridable Function InsertData (table As String, columns As String(), values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of InsertDataOperation)

Parameters

table

String

The table into which the data will be inserted.

columns

String[]

The names of the columns into which the data will be inserted.

values

Object[]

The values to insert, one value for each column in 'columns'.

schema

String

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

Returns

OperationBuilder<InsertDataOperation>

A builder to allow annotations to be added to the operation.

Remarks

See Database migrations for more information and examples.