MigrationBuilder.UpdateData Method

Definition

Namespace:

Microsoft.EntityFrameworkCore.Migrations

Assembly:

Microsoft.EntityFrameworkCore.Relational.dll

Package:

Microsoft.EntityFrameworkCore.Relational v8.0.0

Overloads

UpdateData(String, String, Object, String, Object, String)	Builds an UpdateDataOperation to update a single row of seed data.
UpdateData(String, String, Object, String[], Object[], String)	Builds an UpdateDataOperation to update a single row of seed data.
UpdateData(String, String, Object[], String, Object[], String)	Builds an UpdateDataOperation to update multiple rows of seed data.
UpdateData(String, String, Object[], String[], Object[,], String)	Builds an UpdateDataOperation to update multiple rows of seed data.
UpdateData(String, String[], Object[,], String, Object[], String)	Builds an UpdateDataOperation to update multiple rows of seed data for a table with a composite (multi-column) key.
UpdateData(String, String[], Object[,], String[], Object[,], String)	Builds an UpdateDataOperation to update multiple rows of seed data for a table with a composite (multi-column) key.
UpdateData(String, String[], Object[], String, Object, String)	Builds an UpdateDataOperation to update a single row of seed data for a table with a composite (multi-column) key.
UpdateData(String, String[], Object[], String[], Object[], String)	Builds an UpdateDataOperation to update a single row of seed data for a table with a composite (multi-column) key.
UpdateData(String, String[], String[], Object[,], String[], String[], Object[,], String)	Builds an UpdateDataOperation to update multiple rows of seed data for a table with a composite (multi-column) key.
UpdateData(String, String[], String[], Object[], String[], String[], Object[], String)	Builds an UpdateDataOperation to update a single row of seed data for a table with a composite (multi-column) key.

UpdateData(String, String, Object, String, Object, String)

Builds an UpdateDataOperation to update a single row of seed data.

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

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

Public Overridable Function UpdateData (table As String, keyColumn As String, keyValue As Object, column As String, value As Object, Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumn

String

The name of the key column used to select the row to update.

keyValue

Object

The key value of the row to update.

column

String

The column to update.

value

Object

The new value for the column in the selected row.

schema

String

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

Returns

OperationBuilder<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String, Object, String[], Object[], String)

Builds an UpdateDataOperation to update a single row of seed data.

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

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

Public Overridable Function UpdateData (table As String, keyColumn As String, keyValue As Object, columns As String(), values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumn

String

The name of the key column used to select the row to update.

keyValue

Object

The key value of the row to update.

columns

String[]

The columns to update.

values

Object[]

The new values, one for each column in 'columns', for the selected row.

schema

String

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

Returns

OperationBuilder<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String, Object[], String, Object[], String)

Builds an UpdateDataOperation to update multiple rows of seed data.

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

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

Public Overridable Function UpdateData (table As String, keyColumn As String, keyValues As Object(), column As String, values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumn

String

The name of the key column used to select the row to update.

keyValues

Object[]

The key values of the rows to update, one value per row.

column

String

The column to update.

values

Object[]

The new values for the column, one for each row specified in 'keyValues'.

schema

String

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

Returns

OperationBuilder<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String, Object[], String[], Object[,], String)

Builds an UpdateDataOperation to update multiple rows of seed data.

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

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

Public Overridable Function UpdateData (table As String, keyColumn As String, keyValues As Object(), columns As String(), values As Object(,), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumn

String

The name of the key column used to select the row to update.

keyValues

Object[]

The key values of the rows to update, one value per row.

columns

String[]

The columns to update.

values

Object[,]

The values for each update, where each element of the outer array represents a row specified in 'keyValues', 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<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String[], Object[,], String, Object[], String)

Builds an UpdateDataOperation to update multiple rows of seed data for a table with a composite (multi-column) key.

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

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

Public Overridable Function UpdateData (table As String, keyColumns As String(), keyValues As Object(,), column As String, values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumns

String[]

The names of the key columns used to select the rows to update.

keyValues

Object[,]

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

column

String

The column to update.

values

Object[]

The new values for the column, one for each row specified in 'keyValues'.

schema

String

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

Returns

OperationBuilder<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String[], Object[,], String[], Object[,], String)

Builds an UpdateDataOperation to update multiple rows of seed data for a table with a composite (multi-column) key.

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

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

Public Overridable Function UpdateData (table As String, keyColumns As String(), keyValues As Object(,), columns As String(), values As Object(,), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumns

String[]

The names of the key columns used to select the rows to update.

keyValues

Object[,]

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

columns

String[]

The columns to update.

values

Object[,]

The values for each update, where each element of the outer array represents a row specified in 'keyValues', 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<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String[], Object[], String, Object, String)

Builds an UpdateDataOperation to update a single row of seed data for a table with a composite (multi-column) key.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.UpdateDataOperation> UpdateData (string table, string[] keyColumns, object[] keyValues, string column, object? value, string? schema = default);

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

Public Overridable Function UpdateData (table As String, keyColumns As String(), keyValues As Object(), column As String, value As Object, Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumns

String[]

The names of the key columns used to select the row to update.

keyValues

Object[]

The key values of the row to update, one value for each column in 'keyColumns'.

column

String

The column to update.

value

Object

The new value for the column in the selected row.

schema

String

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

Returns

OperationBuilder<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String[], Object[], String[], Object[], String)

Builds an UpdateDataOperation to update a single row of seed data for a table with a composite (multi-column) key.

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

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

Public Overridable Function UpdateData (table As String, keyColumns As String(), keyValues As Object(), columns As String(), values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumns

String[]

The names of the key columns used to select the row to update.

keyValues

Object[]

The key values of the row to update, one value for each column in 'keyColumns'.

columns

String[]

The columns to update.

values

Object[]

The new values, one for each column in 'columns', for the selected row.

schema

String

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

Returns

OperationBuilder<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String[], String[], Object[,], String[], String[], Object[,], String)

Builds an UpdateDataOperation to update multiple rows of seed data for a table with a composite (multi-column) key.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.UpdateDataOperation> UpdateData (string table, string[] keyColumns, string[] keyColumnTypes, object?[,] keyValues, string[] columns, string[] columnTypes, object?[,] values, string? schema = default);

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

Public Overridable Function UpdateData (table As String, keyColumns As String(), keyColumnTypes As String(), keyValues As Object(,), columns As String(), columnTypes As String(), values As Object(,), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumns

String[]

The names of the key columns used to select the rows to update.

keyColumnTypes

String[]

A list of store types for the columns that will be used to identify the rows that should be updated.

keyValues

Object[,]

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

columns

String[]

The columns to update.

columnTypes

String[]

A list of store types for the columns in which data will be updated.

values

Object[,]

The values for each update, where each element of the outer array represents a row specified in 'keyValues', 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<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.

UpdateData(String, String[], String[], Object[], String[], String[], Object[], String)

Builds an UpdateDataOperation to update a single row of seed data for a table with a composite (multi-column) key.

public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.UpdateDataOperation> UpdateData (string table, string[] keyColumns, string[] keyColumnTypes, object[] keyValues, string[] columns, string[] columnTypes, object[] values, string? schema = default);

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

Public Overridable Function UpdateData (table As String, keyColumns As String(), keyColumnTypes As String(), keyValues As Object(), columns As String(), columnTypes As String(), values As Object(), Optional schema As String = Nothing) As OperationBuilder(Of UpdateDataOperation)

Parameters

table

String

The table containing the data to be updated.

keyColumns

String[]

The names of the key columns used to select the row to update.

keyColumnTypes

String[]

A list of store types for the columns that will be used to identify the rows that should be updated.

keyValues

Object[]

The key values of the row to update, one value for each column in 'keyColumns'.

columns

String[]

The columns to update.

columnTypes

String[]

A list of store types for the columns in which data will be updated.

values

Object[]

The new values, one for each column in 'columns', for the selected row.

schema

String

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

Returns

OperationBuilder<UpdateDataOperation>

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

Remarks

See Database migrations for more information and examples.