更新时间:2023-12-05 13:33:46
首先,你需要创建一个迁移。
First you need to create a migration.
Add-Migration RunSqlScript
然后在生成的迁移文件,你可以写你的SQL。
Then in the generated migration file you can write your SQL.
// PLAIN SQL
Sql("UPDATE dbo.Table SET Created = GETDATE()");
// FROM FILE
var sqlFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"Custom.sql");
Sql(File.ReadAllText(sqlFile));
然后运行
Update-Database