Share via


MigrationBuilder.UpdateData Method

Definition

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to

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

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

Remarks

See Database migrations for more information and examples.

Applies to