Devart Forums

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?

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

AndreyR,

Thanks a lot