Search code examples
entity-frameworkentity-framework-4asp.net-mvc-4

Multiple Diagrams in Model vs One large .EDMX vs Multiple .EDMX

I'm new to the entity and How should I struct my Entity model. We have 600 Database table. So which options should be preferable DB First or EF First? Please let me know which one is better and what the pros/cons (if any) of each alternative.

Thanks.

Solution

  • Let's say you have a User table and a Report table. The Report table has a UserID key to the respective User row. If you have User in Accounts.EDMX and Report in Reporting.EDMX, you will not have a "User.Reports" nor a "Report.User" navigational property.

    As far as I'm concerned, that's the biggest issue in splitting EDMX into multiple files, and the reason I've always added all my tables to a single file...