How to implement a migration to remove a column from a database table?

To delete a column from a database table in a migration, the ALTER TABLE command with the DROP COLUMN operator is usually used. In C# with Entity Framework migrations, this is done through the DropColumn method in the migration class.

Example migration to remove the "OldColumn" from the "Users" table:

public partial class RemoveOldColumn : Migration
{
    protected override void Up(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.DropColumn(
            name: "OldColumn",
            table: "Users");
    }

    protected override void Down(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.AddColumn<string>(
            name: "OldColumn",
            table: "Users",
            type: "nvarchar(max)",
            nullable: true);
    }
}

It is important to ensure that the data in the column being removed is no longer needed or has been backed up, as the operation is irreversible without a backup.