It’s been a few years since I worked with Entity Framework and there have been substantial improvements. Still I have been missing a life cycle view on the database, where the evolution of a database schema during development and maintenance is fully supported. The latest Entity Framework 4.3 release contains EF Migrations which claims to… Continue reading Using Entity Framework to Create a Database
Series: EF Migrations
Adding Indexes with EF Migrations
Most business applications use a database. Creating the database in the first place is the easy part. Continously evolving the database schema during development when multiple team members are doing changes in various parts of the database is one of the hard parts. The really hard part is to be able to upgrade – or… Continue reading Adding Indexes with EF Migrations
Updating a Table with EF Migrations
In my series exploring EF Migrations it is time to look into updates to tables. In this post I’ll make a simple update of a table by adding a column to it. Expanding on the example from the previous posts in this series a TopSpeed column is added to the cars table. Before doing the… Continue reading Updating a Table with EF Migrations
Indexes in Code-Based EF Migrations
In the Adding Indexes with EF Migrations post I showed how to add indexes to a database created by EF Code First with a separate migration step. When using code-based migrations to add a table, there is another, better way to add indexes, if it is done together with the table. If you’ve read my Type Safe… Continue reading Indexes in Code-Based EF Migrations
EF Migrations and a Merge Conflict
To put a bit more stress on EF Migrations I’ll simulate a scenario that should be quite common in a multi developer environment. Developer A and B gets the latest code from the repository. Developer A adds a column and checks in a migration. Developer B adds another column and makes everything ready for checkin.… Continue reading EF Migrations and a Merge Conflict