Here is a scenario – I have two tables – Users and Phones.  Users table has two columns that relate to Phones table – PrimaryPhone and SecondaryPhone.  If you build an EF model with these two tables, you will end up with Users entity with two navigation properties that relate to Phones entity – Phones …

Continue reading ‘Entity Framework and multiple relationships between two tables’ »

I have been using Entity framework as DAL for a CSLA for Silverlight based application.  I have player a role in uncovering a number of issues that make it very hard to use in these circumstances.  Here is my (surely incomplete) list. 1. Foreign keys handling.  The actual IDs that are used as foreign keys …

Continue reading ‘Using Entity Framework as Data Access Layer in n-Tier applications’ »