表结构修改>新增主键或者不能为空的列

// 1. 添加 ID 列
migrationBuilder.AddColumn<long>(
	name: "id",
	table: "data_PaiBanJiLu",
	type: "bigint",
	nullable: false,
	defaultValue: 0L,
	comment: "主键，雪花ID");

// 2. 设置ID 列默认值
string sql = @"
	update data_PaiBanJiLu set id=t1.rowId from 
	(
		select isid,row_number() over (order by isid) as rowId
		from data_PaiBanJiLu
	) as t1
	where data_PaiBanJiLu.isid=t1.isid";
migrationBuilder.Sql(sql);

// 3. 删除旧主键
migrationBuilder.DropPrimaryKey(
	name: "PK_data_PaiBanJiLu",
	table: "data_PaiBanJiLu");

// 4. 添加新主键
migrationBuilder.AddPrimaryKey(
	name: "PK_data_PaiBanJiLu",
	table: "data_PaiBanJiLu",
	column: "id");