How do I use MigrationBuilder DeleteData to delete all rows during a migration?

Question

The documentation is not very helpful - just a list of function signatures, of which the simplest is:

public virtual OperationBuilder DeleteData (string table, string keyColumn, object keyValue, string schema = null);

I am fairly sure I can work out what goes in table, keyColumn and schema, but what value should I put in keyValue if I want to delete all rows?

Answer 1

doesn't look like the DeleteData operations are designed to allow for a delete everything in the table operation. EF uses the keyColumn and keyValue to determine what to delete, i.e. where keyColumn = keyValue. I would recommend using something like this:

migrationBuilder.Sql("DELETE FROM [table]", true);

https://github.com/dotnet/efcore/blob/main/src/EFCore.Relational/Migrations/Operations/DeleteDataOperation.cs

https://github.com/dotnet/efcore/blob/main/src/EFCore.Relational/Migrations/MigrationBuilder.cs (about line 1400)