EF Migrations

[buldo]

Hello.
What is best way for working with EF migrations with this buildpack?

[noliar]

You can add some prepublish script into project.json.

eg.

:( But it doesn't copy the sqlite database file to the output directory using dotnet publish.

[buldo]

Sqlite - not a problem. I'll use PostgreSQL that provided by Heroku :)

[buldo]

Actually it does not works.
At a prepublish step heroku system environments looks not configured so right ConnectionString cannot be obtained :(

[noliar]

I don't know whether the DATABASE_URL value can be used in Npgsql directly or not.

I just tested it using hard-coding ConnectionString, and it seems to work.
noliar/ASP.NET-Core-Sample@b59e3a7
https://netcore.herokuapp.com/Account/Register

Or setting DefaultConnection in Config Vars.

[mattiascibien]

I tried with this and unfortunately it seems that I cannot attach to the postgresql instance due to ssl being off. And when enabling it te certificate is not accepted.

[buldo]

@mattiascibien I have an solution for Heroku.
At first add support for Environment Variables in setup method

public Startup(IHostingEnvironment env)
{
    var builder =
                new ConfigurationBuilder().SetBasePath(env.ContentRootPath)
                    .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
                    .AddJsonFile($"appsettings.{env.EnvironmentName}.json", optional: true)
                    .AddEnvironmentVariables();

After that you can use this code in ConfigureServices method

public void ConfigureServices(IServiceCollection services)
        {
            string connectionString;
            string herokuDatabaseUrl = Configuration["DATABASE_URL"];
            if (string.IsNullOrWhiteSpace(herokuDatabaseUrl))
            {
                var receiveDataString = Configuration["RECEIVE_DATA"];
                if (string.IsNullOrWhiteSpace(receiveDataString))
                {
                    // We are in local dev environment
                    connectionString = Configuration.GetConnectionString("DefaultConnection");
                }
                else
                {
                    // We are in a process of building and deploying at heroku
                    dynamic receiveData = JsonConvert.DeserializeObject(receiveDataString);
                    connectionString = receiveData.push_metadata.env.DefaultConnection + "SSL Mode=Require;Trust Server Certificate=true;Pooling=false;";
                }
            }
            else
            {
                // We are in production env at Heroku
                connectionString = DbHelpers.DatabaseUrlToPostgreConnectionString(herokuDatabaseUrl);

            }

            services.AddDbContext<ApplicationDbContext>(options => options.UseNpgsql(connectionString));

Full working example here

[mattiascibien]

@buldo I actually used the Env var ConnectionStrings:DefaultConnection and it worked like a charm. Now i have a problem with #4 .