Disable Entity Framework Code First Initialization Logic

When you use the Entity Framework Code First approach to build your database, EF’s default behavior is to verify if a database exists when the application runs the first time. In case it does not exist, EF creates it. There might exist some situations when there is no need to …

Handle Race Conditions / Concurrency in Code First Entity Framework Applications

Preface A common scenario in developing applications is the handling of concurrent database updates. Given there is an application to manage customers, that is used by multiple users simultaneous. User U1 reads the data of customer C1. While user U1 is looking at this data, user U2 reads the data …

Paging Made Easy with ASP.NET MVC 5, Entity Framework 6 and PageList.Mvc

Preface In former days, implementing paging sometimes took a little bit of time. That was independent from the used platform, native Windows Client or Web or whatever. Fortunately, that was then and this is now. Implementing paging in an ASP.NET MVC 5 Entity Framework 6 application really became simple. Just …

Create a 1:1 Table Relationship using Entity Framework

Preface My database roots are pure SQL. When I create a database, I use an Excel sheet for documentation purposes, which creates SQL statements to build up the tables. Table relationships (parent / child) with foreign keys I do define by hand, like the good old craftsmen do. It’s simple …