Relationship between models table?

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
rogerio.bassete
Posts: 15
Joined: Sat 05 Aug 2006 20:55
Location: Brazil

Relationship between models table?

Post by rogerio.bassete » Thu 10 Jun 2010 13:37

Hello,

My database has more than 800 tables.

To facilitate the management and maintenance, think of dividing it into several models.

1) How to link tables between different models?

2) How many tables do you recommend a model to avoid loss of performance?

3) How are you working with databases with lots of tables?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 11 Jun 2010 14:11

1. It will be a set of problems to link a table from one context to another. For more information take a look at this link.
2. We recommend to divide your model into parts of 100-200 tables in dependence of the number of associations.
3. Databases with lots of tables provide some problems in the model generation (it is generated in memory first because of EF design). The other problem is to oerform the layout of the large number of teh tables.
Take a look at these two articles in ADO.NET Team blog:
http://blogs.msdn.com/b/adonet/archive/ ... art-1.aspx
http://blogs.msdn.com/b/adonet/archive/ ... art-2.aspx

rogerio.bassete
Posts: 15
Joined: Sat 05 Aug 2006 20:55
Location: Brazil

Post by rogerio.bassete » Fri 11 Jun 2010 14:21

AndreyR,

Thanks a lot

Post Reply