How to create dynamic environment sequencing columns in .Net Core EF migrations with PostgreSQL / Npgsql

Recently I’ve been building out a .Net Core WebAPI microservice that talks to a PostgreSQL database. We’re diving into the world of HATEOS so we want to have a Url parameter that correlates to the Id of the record once it is created. Additionally, we’re using Docker to better manage our deployments, so we want to be able to have this URL change when building the database in each environment as part of our Entity Framework migrations process.

It’s a bit tricky, but doable. Here’s how you get your “ducks in a row” in order to make this happen.

Continue reading “How to create dynamic environment sequencing columns in .Net Core EF migrations with PostgreSQL / Npgsql”

Quick Tip: Manually Run EF Migrations on External Databases

Entity Framework migrations are a great thing. They’ve made my development life a LOT easier. Automated migrations can cause problems, especially on a project with multiple developers involved. For that, we use manual migrations through the Package Manager Console.

But how do you manually run these migrations against your test (or live) server when your deployment tool doesn’t run them? If you have access to the database in question, you can add the ConnectionString and ProviderName parameters at the Package Manager Console prompt and make life a lot easier:

Update-Database -ConnectionString "MY_CONNECTION_STRING" -ConnectionProviderName "System.Data.SqlClient"

You can pull your connection string direct from your web.config transform, no special “magic” needed.

Enjoy! Continue reading “Quick Tip: Manually Run EF Migrations on External Databases”


Database Migrations with Azure EF7 and DNX

With the newest release of ASP.Net 5 (vNext) and Entity Framework 7, it appears that the traditional web.config transform method and startup code will no longer work to have your database migration scripts automatically run when you deploy your code from source control to Azure. Here’s a new way that you can accomplish the same task and keep your continuous integration setup running smoothly. Continue reading “Database Migrations with Azure EF7 and DNX”