When it comes to mapping inheritance hierarchies to database tables using an ORM, there are a lot of different options. Though it definitely has drawbacks, one of the most popular method is 'table-per-hierarhy' (TPH). TPH…
In a previous post I tried to give reasons why you should use the repository and unit of work design patterns even if you have a modern, object-relational framework like Entity Framework (well, modern would…
Using Entity Framework Code First, you have the option of specifying indices on columns that are translated to migrations and from that you can generate the SQL script or update the database. With EF 6.…
In my previous post I told the tale of how I used a wrong (but still awesome) tool to solve a problem. The problem was that I had not known the default conventions when using…
... you see everything as a nail. I'm usually not the one to cite clichés, but for this one I make an exception. It is very, very true, especially in the software engineering business. If all…