MigrationBuilder.DeleteData Method

Definition

Namespace:

Microsoft.EntityFrameworkCore.Migrations

Assembly:

Microsoft.EntityFrameworkCore.Relational.dll

Package:

Microsoft.EntityFrameworkCore.Relational v8.0.0

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)

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

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.

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.

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.

DeleteData(String, String, String, Object, String)

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

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.

DeleteData(String, String, String, Object[], String)

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

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.

DeleteData(String, String[], Object[,], String)

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

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.

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.

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.

DeleteData(String, String, Object[], String)

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

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.

DeleteData(String, String, Object, String)

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

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

OperationBuilder<DeleteDataOperation>

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

Remarks

See Database migrations for more information and examples.