entity framework and 1000 tables and 100's of relationships

Oct 20, 2009 at 3:33 AM

Using entity to support that much schema is unheard of can you elaborate on some of the challenges you had.  You mention breaking the model in to smaller pieces.  Did you modularize so that you had an entity for Order Entry, Labor Entry, Part Entry, etc...  I struggle with this... For instance Part Entry alone has so many touch points in to all the models do you have to replicate it in to all of entities that would use it...

How would a schema change be managed would you have to make the change in each of the entities that would include the table where the schema was changed...

It is disapointing that a huge vendor like Microsoft does not have an out of the box solution to support enterprise schema.