Search code examples
.netentity-frameworkarchitecturemygeneration

DataLayer of a new Application: MyGeneration and/or Entity-Framework

The platform is ASP.Net 3.5sp1, with an Oracle db. We've considered both MyGeneration and Entity Framework for time and convenience in the DataLayer (and maybe some base classes in the Business Layer).

My questions are:

  1. Any pros and cons of using Entity Framework vs MyGeneration?

  2. Any thoughts on using MyGeneration to generate code that would use Entity Framework?

I'm hoping for feedback from developers with experience in both, but any feedback is welcome.

Research we have done so far: We have a team member who is proficient in MyGeneration. We've watched several tutorial videos and read intro docs of Entity Framework.

Note: We are aware of the need to purchase an Entity Framework data provider for Oracle if Entity Framework is a part of the solution.

Also, we are aware of Entity-Spaces, but it does not appear to be a candidate for other reasons.

Solution

  • If you have a MyGeneration export, then you might want to stick with that. As for EntityFramework. I have used it for a few small projects and think it is perfect when working with smallish systems (fewer than 10-15 tables).

    Also, if you are debating all of this because nothing 'really' fits your solution, than consider one of my two alternative options:

    • Get a copy of CodeSmith and create your own templates. That way you can 'start' with EntityFramework (used by your generated code) and switch to something else if you have problems.
    • Consider .NET Tiers. It has worked quite well for my larger projects in the past.