.net - Organizing large no of tables in Entity Framework -
.net - Organizing large no of tables in Entity Framework -
i have couple of queries regards entity framework:
my database has on 100 tables including of master, lookup , kid tables. 1 operation of save may save info in 25 different tables. trying figure out best possible way organize entities. whether should table wise or should operation wise. have best practices or suggested practices defined in regards?
since in above scenario not have pure crud operations, should maintain 1 edmx file or split them multiple edmx files , how?
actually, there no best practices concerning big models, depends on personal experience. crud operations, here ideas: can either write transactional code using transactionscope, approach allow table-level control. in different case can write set of stored procedures perform finish operations. in case wou have operation-level control. edmx splitting, makes sense, e.g., in case database has independent part.
.net entity-framework architecture
Comments
Post a Comment