Thursday, November 26, 2009

Creating a Reference Project Part 1 - Setting Up the Database

This is a modified version of the (in)famous Northwind database.

The database has all kind of relationship that can be used to test various OR/Mappers like NHibernate and the Entity Framework

  • Many-To-Many
  • One-To-Many
  • Self join table (Employees)
  • Saving binary objects (photo on Employees)

It also give us the possibility of nested collections Employee->Orders->OrderLines

Northwind Diagram