Are there any performance considerations for large Entity Framework Models/Contexts?

itnifl
itnifl used Ask the Experts™
on
Are there any performance considerations for large Entity Framework Models/Contexts?
Are many smaller contexts faster / better than one large of the same database? or vice versa?
And why?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017

Commented:
If I understand your question, deals whether it is better to have a single large table versus multiple.
There is a balancing deals with minimizing storage while maximizing valuable data.
A single contex thas many duplicate information consuming storage space.

The trade off deals with query And complexity......
Programmer
Commented:
Entity Framework models are not related to sizes of tables.
I have researched the topic, and it seems that the model size can affect the speed of the queries and usage of the EF context. Mostly one time per application domain, but also at certain steps in the process at every query request.

I would however be interested in how much the model size affects query execution for each different version of Entity Framework.
itniflProgrammer

Author

Commented:
Found the solution

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial