I have a line of business application "MyApp" in C# using EF. Layers are separated as

  • MyResusableLib.DataAccess // Class Lib: EF based utils, extension methods,
  • MyApp.DataAccess // Class Lib: EF edmx, generated Model classes
  • MyApp.DataServices // Class Lib: Depends on Model classes in MyApp.DataAccess (Note: Services are just POCOs and has nothing to do with a web API. For example PaymentService.Storno(...))
  • etc

I discovered, that some universal tables (at least five) will be common in all my future line of business applications. So implemented high level services should not be copied over MyApp1.DataServices to MyApp2.DataServices, instead should be placed a newly created MyReusableLib.DataServices class lib


The EF context and model classes will be in future created MyAppX.DataAccess. However MyReusableLib.DataServices depends on those model classes.


What is the best architecture to overcome the problem, and enjoy a MyReusableLib.DataServices with its high level services over the persistent storage?

Proposed Solution:

Only one solution comes in my mind, but I am not sure. Especially I do not know if there are drawbacks, and also do not know if there is a better practice. One for sure: I would like to end with a DRY solution.

  • I will have two EF edmxs and contexts (pointing to the very same database when connection strings will be configured in my future MyAppX.)
  • The first EF edmx context will be defined in MyReusableLib.DataServices and will contain the five reusable tables/entites.The implemented services (also in the assembly) can use those model classes.
  • The second EF edmx context will be defined in my future MyAppX. Will contain all specific tables and will not contain the reusable tables.
  • The physical database for MyAppX will contain both the reusable tables and the specific tables.
  • Is it possible for you to do code-first design instead of model-first, or is that a requirement? Apr 27, 2016 at 17:52
  • Actually it is DB first and it is mandatory. Anyway thanks for the question.. Apr 27, 2016 at 18:11
  • I'm interested by what are you trying to do ,I would know if you have been able to implimante this architecture. Mar 8, 2017 at 13:03

1 Answer 1

  • MyModels - class lib. No dependencies

  • IMyDataRepository - interface. Depends on MyModels

  • MyDataRepository_EfSql - depends on MyModels and IMyDataRepository
    and Entity framework

    • private EF Context private EF Models

    • private EF Model to Domain Model mapping

  • MyApplication - depends on all three. But the repository is loosely
    coupled via dependency injection

  • Model classes are generated by the EF .edmx. Also the generated EF context uses (depends on its model classes Apr 27, 2016 at 9:31
  • 1
    You map those auto generated classed to your real models
    – Ewan
    Sep 24, 2016 at 20:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.