MigrationBuilder.UpdateData Method
Definition
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
UpdateData(String, String, Object, String, Object, String)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
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
Entity Framework