- Include the myget feed for this package,
https://www.myget.org/F/atquin, or in global.json add thesrcdirectory of this repo to yourprojectslist. - Reference Atquin.EntityFramework.Migrations in your DataContext xproj;
"dependencies": {
"EntityFramework6.Npgsql": "3.0.3", <!-- if you want npgsql -->
"Atquin.EntityFramework.Migrations": "1.0.0-rc1-final"
},
"commands": {
"ef": "Atquin.EntityFramework.Migrations"
}
- If you don't have already, add a DataContextFactory that will create a DataContext using your config.json's connection string;
public class MyContextFactory : IDbContextFactory<MyDataContext>
{
private IConfiguration _config;
public MyContextFactory()
{
_config = new ConfigurationBuilder().AddJsonFile("config.json").Build();
}
public MyDataContext Create()
{
return new MyDataContext(_config["Data:DefaultConnection:ConnectionString"]);
}
}
- Add a configuration to Migrate/Seed data;
namespace MyProject.Data.Migrations
{
internal sealed class Configuration : DbMigrationsConfiguration<MyDataContext>
{
public Configuration()
{
AutomaticMigrationsEnabled = false;
MigrationsDirectory = "Migrations"; // should match the end of your Namespace above
}
protected override void Seed(MyDataContext context)
{
Console.WriteLine("Executing seed...");
...
}
}
}
- Open command prompt and execute the following;
cd /your/datacontext/directory
dnx ef add MigrationName
- VS2015 will then immediately generate a same-named *.cs for the *.resx file created. Delete that *.cs file.
- Now you can update the database;
dnx ef update
See the options below. Example;
dnx ef update -c "Data Source=myServerAddress;
location=myDataBase;User ID=myUsername;password=myPassword;" -p Npgsql
dnx ef add --help
Usage: ef add [arguments] [options]
Arguments:
[name] Migration name label
Options:
-?|-h|--help Show help information
-c|--connectionstring The connection string
-p|--provider The provider name
-i|--ignore Ignore model changes
dnx ef update --help
Usage: ef update [options]
Options:
-?|-h|--help Show help information
-c|--connectionstring The connection string
-p|--provider The provider name