Number of tables in one Entity Data Model (EDMX)

[Maurizio Coffinardi]

Hi,
I'm developing an ASP.NET application and I'm going to use ADO.NET Entity
Framework. The underlying database contains almost 800 tables.
Do you think I can create just one data model with all the tables and
relationships or the best way is to split it in more .edmx files?
Thinking about performances I thought to choose the first option but it's a
bit hard for me to do it because every table is directly or indirectly
related with the other tables and I don't know where "to break" the data
model.
Any suggestion?
Thank you.

 

[Frans Bouma [C# MVP]]

Hi,
I'm developing an ASP.NET application and I'm going to use ADO.NET Entity
Framework. The underlying database contains almost 800 tables.
Do you think I can create just one data model with all the tables and
relationships or the best way is to split it in more .edmx files?
Thinking about performances I thought to choose the first option but it's a
bit hard for me to do it because every table is directly or indirectly
related with the other tables and I don't know where "to break" the data
model.

I don't think you'll get the designer of EF up and running with 800
entities in it. Have you tried creating a model from it?

You can of course split the project, but why would anyone want to do that?

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------