MigrationBuilder.DeleteData 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
| DeleteData(String, String[], String[], Object[,], String) |
Builds a DeleteDataOperation to delete multiple rows of seed data from a table with a composite (multi-column) key. |
| DeleteData(String, String[], String[], Object[], String) |
Builds a DeleteDataOperation to delete a single row of seed data from a table with a composite (multi-column) key. |
| DeleteData(String, String, String, Object, String) |
Builds a DeleteDataOperation to delete a single row of seed data. |
| DeleteData(String, String, String, Object[], String) |
Builds a DeleteDataOperation to delete multiple rows of seed data. |
| DeleteData(String, String[], Object[,], String) |
Builds a DeleteDataOperation to delete multiple rows of seed data from a table with a composite (multi-column) key. |
| DeleteData(String, String[], Object[], String) |
Builds a DeleteDataOperation to delete a single row of seed data from a table with a composite (multi-column) key. |
| DeleteData(String, String, Object[], String) |
Builds a DeleteDataOperation to delete multiple rows of seed data. |
| DeleteData(String, String, Object, String) |
Builds a DeleteDataOperation to delete a single row of seed data. |
DeleteData(String, String[], String[], Object[,], String)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
Builds a DeleteDataOperation to delete multiple rows of seed data from a table with a composite (multi-column) key.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, string[] keyColumnTypes, object[,] keyValues, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, string[] keyColumnTypes, object?[,] keyValues, string? schema = default);abstract member DeleteData : string * string[] * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string[] * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumns As String(), keyColumnTypes As String(), keyValues As Object(,), Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumns
- String[]
The names of the key columns used to select the rows to delete.
- keyColumnTypes
- String[]
The store types for the columns that will be used to identify the rows that should be deleted.
- keyValues
- Object[,]
The key values of the rows to delete, where each element of the outer array represents a row, and each inner array contains values for each of the key columns in 'keyColumns'.
- 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
DeleteData(String, String[], String[], Object[], String)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
Builds a DeleteDataOperation to delete a single row of seed data from a table with a composite (multi-column) key.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, string[] keyColumnTypes, object[] keyValues, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, string[] keyColumnTypes, object?[] keyValues, string? schema = default);abstract member DeleteData : string * string[] * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string[] * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumns As String(), keyColumnTypes As String(), keyValues As Object(), Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumns
- String[]
The names of the key columns used to select the row to delete.
- keyColumnTypes
- String[]
The store types for the columns that will be used to identify the rows that should be deleted.
- keyValues
- Object[]
The key values of the row to delete, one value for each column in 'keyColumns'.
- 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
DeleteData(String, String, String, Object, String)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
Builds a DeleteDataOperation to delete a single row of seed data.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, string keyColumnType, object keyValue, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, string keyColumnType, object? keyValue, string? schema = default);abstract member DeleteData : string * string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumn As String, keyColumnType As String, keyValue As Object, Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumn
- String
The name of the key column used to select the row to delete.
- keyColumnType
- String
The store type for the column that will be used to identify the rows that should be deleted.
- keyValue
- Object
The key value of the row to delete.
- 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
DeleteData(String, String, String, Object[], String)
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
- Source:
- MigrationBuilder.cs
Builds a DeleteDataOperation to delete multiple rows of seed data.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, string keyColumnType, object[] keyValues, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, string keyColumnType, object[] keyValues, string? schema = default);abstract member DeleteData : string * string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumn As String, keyColumnType As String, keyValues As Object(), Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumn
- String
The name of the key column used to select the row to delete.
- keyColumnType
- String
The store type for the column that will be used to identify the rows that should be deleted.
- keyValues
- Object[]
The key values of the rows to delete, one value per 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
DeleteData(String, 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 a DeleteDataOperation to delete multiple rows of seed data from a table with a composite (multi-column) key.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, object[,] keyValues, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, object?[,] keyValues, string? schema = default);abstract member DeleteData : string * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string[] * obj[,] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumns As String(), keyValues As Object(,), Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumns
- String[]
The names of the key columns used to select the rows to delete.
- keyValues
- Object[,]
The key values of the rows to delete, where each element of the outer array represents a row, and each inner array contains values for each of the key columns in 'keyColumns'.
- 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
DeleteData(String, 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 a DeleteDataOperation to delete a single row of seed data from a table with a composite (multi-column) key.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, object[] keyValues, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string[] keyColumns, object?[] keyValues, string? schema = default);abstract member DeleteData : string * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string[] * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumns As String(), keyValues As Object(), Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumns
- String[]
The names of the key columns used to select the row to delete.
- keyValues
- Object[]
The key values of the row to delete, one value for each column in 'keyColumns'.
- 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
DeleteData(String, 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 a DeleteDataOperation to delete multiple rows of seed data.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, object[] keyValues, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, object[] keyValues, string? schema = default);abstract member DeleteData : string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string * obj[] * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumn As String, keyValues As Object(), Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumn
- String
The name of the key column used to select the row to delete.
- keyValues
- Object[]
The key values of the rows to delete, one value per 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
DeleteData(String, 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 a DeleteDataOperation to delete a single row of seed data.
public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, object keyValue, string schema = default);public virtual Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation> DeleteData (string table, string keyColumn, object? keyValue, string? schema = default);abstract member DeleteData : string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>
override this.DeleteData : string * string * obj * string -> Microsoft.EntityFrameworkCore.Migrations.Operations.Builders.OperationBuilder<Microsoft.EntityFrameworkCore.Migrations.Operations.DeleteDataOperation>Public Overridable Function DeleteData (table As String, keyColumn As String, keyValue As Object, Optional schema As String = Nothing) As OperationBuilder(Of DeleteDataOperation)Parameters
- table
- String
The table from which the data will be deleted.
- keyColumn
- String
The name of the key column used to select the row to delete.
- keyValue
- Object
The key value of the row to delete.
- 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