Code First Entity Framework with MVC4 and Visual Studio 2012

I am a huge fan of ADO.NET’s Entity Framework (EF) that bridges the gap between modelling entities\business logic and data engines. It allows web-programmers like myself to focus on the solution instead of worrying about properly setting up databases, keys, foreign-keys, constraints, and indexes. Because of it’s quick turn-around, EF is perfect for prototyping and proof of concepts. For enterprise sized solutions, …

Normalizing a Database: Part 1

As a quick refresher, and for a way to solidify my on-the-job experience with some RDB theory, I’ve decided to talk about normal forms. For obvious reasons we want to reduce data redundancy in our DB: security, resources, manageability, data integrity… But what’s the best process to do this? The best solution is to turn to normal forms. Normal forms …

Migrating the full Application Services database schema

When you need to run ASP.Net Membership from a Shared Server One of the main advantages of ASP.NET is it’s out of the box user management system. With ASP.NET membership, the developer has a proven service for validating and storing user credentials. If you’re interested in all the possibilities of this technology, read this MSDN article. Because the IIS and …