我失去了从控制台应用程序运行迁移的文件？ [英] What files am I missing wile running migrations from a console app?
问题描述
使用Entity Framework 6和一个工作的PostgreSQL数据库加上连接我试图运行 Add-Migration 和 Update-Database 命令并通过控制台应用程序创建更新脚本。可以从控制台运行命令，因为它只是围绕API轻薄，请参见这个SO答案我使用的例子。
With Entity Framework 6 and a working PostgreSQL database plus connection I am trying to run the Add-Migration and Update-Database commands and create an update script via a console app. It is possible to run the commands from a console since it are "just thin wrapper around an API", see this SO-answer for the example I used.
创建迁移工作，创建三个常规文件，即： p>
The creation of migrations work, three regular files are created, namely:
Initial.cs
Initial.Designer.cs
Initial.resx
Initial.cs
Initial.Designer.cs
Initial.resx
这是控制台应用程序不适用于更新数据库。
Here's the console app that does not work for Update-Database.
public static void Main()
{
// Specify the name of the database migration
// Note: make sure to create a new name for each new migration and prefix with
const string MIGRATION_NAME = "Initial";
// END USER INPUT
// Get executing path from which the location of the Update_Scripts and new
// Migrations can be determined.
var executingPath = AppDomain.CurrentDomain.BaseDirectory;
// Write to database (PowerShell: Update-Database)
var config = new Configuration();
var migrator = new DbMigrator(config);
migrator.Update(); // <= HERE IT CRASHES!
// Now create the PostgreSQL update script.
var scriptor = new MigratorScriptingDecorator (migrator);
string script = scriptor.ScriptUpdate (sourceMigration: null, targetMigration: null);
var updateScriptPath = Regex.Replace (executingPath, "Zk.Migrations/.*",
"Zk/App_Data/Update_Scripts");
File.WriteAllText (updateScriptPath + MIGRATION_NAME + ".postgresql", script);
Console.WriteLine ("Update script {0} written to App_Data/Update_Scripts folder", MIGRATION_NAME);
}
这里配置类看起来如下：
public class Configuration : DbMigrationsConfiguration<ZkContext>
{
public Configuration ()
{
AutomaticMigrationsEnabled = false;
SetSqlGenerator("Npgsql", new PostgreSqlMigrationSqlGenerator());
}
}
其中 PostgreSqlMigrationSqlGenerator 类来自此GitHub存储库。
当我尝试运行上面的Update-Database部分时，控制台应用程序在 migrator.Update（）; 上崩溃。这是例外：
When I try to run the Update-Database part above the console app crashes on migrator.Update();. This is the exception:
找不到适合指定文化或中立文化的资源。确保Zk.Migrations.Initial.resources在编译时正确嵌入或链接到程序集Zk.Migrations中，或者所有需要的所有卫星程序集都可加载和完全签名。
Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "Zk.Migrations.Initial.resources" was correctly embedded or linked into assembly "Zk.Migrations" at compile time, or that all the satellite assemblies required are loadable and fully signed.
这里是堆栈跟踪：
System.Data.Entity.Migrations.DbMigrator 。
中的.EnsureDatabaseExists（mustSucceedToKeepDatabase =
{System.Action}）在
$ b中的System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists
（mustSucceedToKeepDatabase = {System.Action}） $ b System.Data.Entity.Migrations.DbMigrator.Update（targetMigration =（null））in
System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update（）in
Zk.Migrations.MigrationsTool.Main（）in /home/erwin/zaaikalender/Zk.Migrations
/MigrationsTool.cs:78
System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists (mustSucceedToKeepDatabase=
{System.Action}) in System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists
(mustSucceedToKeepDatabase={System.Action}) in
System.Data.Entity.Migrations.DbMigrator.Update (targetMigration=(null)) in
System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update () in
Zk.Migrations.MigrationsTool.Main () in /home/erwin/zaaikalender/Zk.Migrations
/MigrationsTool.cs:78
我不知道如何提供正确的资源并让脚本工作。应该首先运行启用迁移，如果是这样？我希望有人可以帮助我！谢谢。
I don't know how to provide the right resources and get the script to work. Should I run Enable-Migrations first and if so how? I hope someone can help me out! Thanks.
推荐答案
需要做两件事才能让控制台应用程序工作，以添加代码优先迁移，创建一个脚本并更新数据库：
Two things that need to be done to get the console app working to add a code-first migrations, create a script and update the database:
- 给
.cs。，.resx和.Designer.cs添加与迁移脚手架名称相同的迁移时所创建的文件，而不迁移MigrationIdpreprended。否则文件无法找到。 - 右键单击资源
.resx文件，并选择BuildActionEmbeddedResource，否则资源无法找到。
- Give the
.cs.,.resxand.Designer.csfiles that are created when adding a migration the same name as the migration scaffolding name without the migration'sMigrationIdpreprended. Otherwise the files could not be found. - Right click on the resources
.resxfile and chose BuildAction "EmbeddedResource", otherwise the resources cannot be found.
控制台应用程序的完整工作脚本（使用 PostgreSqlMigrationSqlGenerator ）：
Full working script of the console app (which uses the PostgreSqlMigrationSqlGenerator):
/// <summary>
/// Class used to generate the code migrations and SQL script based on the Models and update the database.
/// (I.e., runs PowerShell's Add-Migration and Update-Database, and creates a PostgreSQL script.)
/// See: http://stackoverflow.com/questions/20374783/enable-entity-framework-migrations-in-mono#20382226
///
/// Usage: run by setting Zk.Migrations as Startup project and pressing play.
///
/// Classes of namespace EntityFramework.PostgreSql obtained from:
/// https://github.com/darionato/PostgreSqlMigrationSqlGenerator. License is included.
/// </summary>
class MigrationsTool
{
/// <summary>
/// The entry point of the program, where the program control starts and ends.
/// </summary>
public static void Main()
{
// USER INPUT /////////////////////////////////////////////////////////////////////////////////
// Always first create a new database migration with DatabaseStep.ADD_MIGRATION,
// and include the created files in the project and set resource file to EmbeddedResource.
// After creating a migration run UPDATE_DATABASE to update the database.
const DatabaseStep step = DatabaseStep.UPDATE_DATABASE;
// Specify the name of the database migration in case of ADD-MIGRATION.
// Note: Make sure to create a new name for each new migration.
// After creating migration include the files in the folder by right clicking on
// Zk.Migrations and selecting "Add files from folder". Then add the .cs, .resx and
// .Designer.cs files with the name specified below.
// Last but not least set the .resx file's build action to EmbeddedResource by right
// clicking on it.
// Make sure that the Setup.postgresql script has run manually to create the database user.
const string MIGRATION_NAME = "CalendarAndUser";
// END USER INPUT /////////////////////////////////////////////////////////////////////////////
// Get executing path from which the location of the Update_Scripts and new Migrations can be determined.
var executingPath = AppDomain.CurrentDomain.BaseDirectory;
// Add a new migration (PowerShell: Add-Migration)
if (step == DatabaseStep.ADD_MIGRATION) {
// Initialize the wrapper classes around the Entity Framework PowerShell API.
var config = new Configuration();
var scaffolder = new MigrationScaffolder(config);
var migration = scaffolder.Scaffold(MIGRATION_NAME);
// Place migration code in main project "Migrations" folder and migration scripts in "App_Data"
var migrationsPath = Regex.Replace(executingPath, "bin/.*", "");
// Write migrations
File.WriteAllText (migrationsPath + MIGRATION_NAME + ".cs", migration.UserCode);
File.WriteAllText (migrationsPath + MIGRATION_NAME + ".Designer.cs", migration.DesignerCode);
using (var writer = new ResXResourceWriter (migrationsPath + MIGRATION_NAME + ".resx"))
{
foreach (var resource in migration.Resources)
{
writer.AddResource(resource.Key, resource.Value);
}
}
Console.WriteLine("EF code migration {0} written to Migrations folder...\n\n" +
"Next step is to include the .cs, .resx and .Designer.cs file in the project" +
"by right clicking on the project and selecting " +
"\"Add files from folder.\"\n" +
"Then right click on {0}.resx and set build action to \"EmbeddedResource\""
, migration.MigrationId);
}
else if (step == DatabaseStep.CREATE_SCRIPT)
{
var config = new Configuration();
var migrator = new DbMigrator(config);
var scriptor = new MigratorScriptingDecorator(migrator);
// Determine name of the previous run migration if exists.
string lastMigration = migrator.GetDatabaseMigrations().LastOrDefault();
// Get the script
string script = scriptor.ScriptUpdate(sourceMigration: lastMigration, targetMigration: MIGRATION_NAME);
// Create the PostgreSQL update script based on last migration on database and
// current migration.
string formattedScript = string.Format
("/* * * * * * * * * * * * * * * * * * * * * * *\n" +
" *\n" +
" * Migration:\t\t{0}\n *\n" +
" * Date and time:\t{1}\n" +
" *\n" +
" * * * * * * * * * * * * * * * * * * * * * * */\n\n" +
"{2}",
MIGRATION_NAME,
DateTime.Now,
script);
// Write string to file in Migrations folder of main project
var updateScriptPath = Regex.Replace(executingPath, "Zk.Migrations/.*", "Zk/App_Data/Migrations/");
File.WriteAllText(updateScriptPath + MIGRATION_NAME + ".postgresql", formattedScript);
Console.WriteLine("Update script {0}.postgresql written to Zk/App_Data/Migrations folder.\n" +
"Please include the script by right clicking on the folder and selecting " +
"\"Add files to folder\"," +
"\nIt is recommended to prefix the filename with the current datetime.",
MIGRATION_NAME);
}
// If a new migration is created the database can be updated. (PowerShell: Update-Database)
else if (step == DatabaseStep.UPDATE_DATABASE)
{
var config = new Configuration();
var migrator = new DbMigrator(config);
// Write to database
migrator.Update();
// Show which migrations were applied.
var migrationNames = string.Join(", ", migrator.GetDatabaseMigrations().ToArray().First());
Console.WriteLine("Applied migration {0} to database.", migrationNames);
}
}
/// <summary>
/// Enumeration for specifying the step in the migration.
/// </summary>
private enum DatabaseStep
{
ADD_MIGRATION,
CREATE_SCRIPT,
UPDATE_DATABASE
}
}
这篇关于我失去了从控制台应用程序运行迁移的文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
