Entity Framework 5 vs Telerik OpenAccess ORM (specifically)

entity-framework entity-framework-5 telerik-open-access
dimoss picture dimoss · Jun 29, 2012 · Viewed 7.5k times · Source

I am starting a new project and want advice on choosing an ORM. I know this topic has been brought up before, but this topic is specific to either Entity Framework 5 (not 4) or Telerik OpenAccess ORM.

The project will reside on Windows Azure and use Windows Azure SQL Database. I will migrate it to .NET 4.5 once 4.5 is live on Azure.

I am currently a Telerik Ultimate Collection subscriber.

Does anyone in the know have any pros/cons for this scenario? I am slightly leaning towards Telerik OpenAccess at the moment.

Thanks

Answer

user1712937 picture user1712937 · Dec 17, 2012

First off, the comment:

"This is not really an answer - but you may want to keep your eye on the following if you intend to use OpenAccess against Azure: telerik.com/community/forums/orm/orm-express/… " does not reflect the correct product.

Deals with the FREE version of OpenAccess. Jayantha specified in his question that he is a "Ultimate Collection Subscriber".

The OpenAccess ORM is now compatible with Azure.

Some reasons to choose OpenAccess ORM over Entity Framework 5:

  • Batch operations in Visual Designer
  • Code generation for WCF Services
  • Code generation for ASP.Net Web API Services
  • Dynamic Model Modifications
  • Custom Types Framework
  • Built-in Validation Frameworks
  • .NET 3.5 Support
  • Pessimistic Concurrency
  • Built-In L2 Cache
  • Advanced Connection Pooling
  • Pure XML mapping

What you lose when using OpenAccess that EF5 provides:

  • Self-Tracking Entities
  • Full support for Enumerations in Visual Designer (Partial support only)

Go figure!

Related questions

Entity Framework Join 3 Tables

I'm trying to join three tables but I can't understand the method... I completed join 2 tables var entryPoint = dbContext.tbl_EntryPoint .Join(dbContext.tbl_Entry, c => c.EID, cm => cm.EID, (c, cm) => new { UID = cm.OwnerUID, …

Read More
Non-static method requires a target

I have a controller action that works fine on Firefox both locally and in production, and IE locally, but not IE in production. Here is my controller action: public ActionResult MNPurchase() { CalculationViewModel calculationViewModel = (CalculationViewModel)TempData["calculationViewModel"]; decimal OP = landTitleUnitOfWork.Sales.…

Read More
EF LINQ include multiple and nested entities

Ok, I have tri-leveled entities with the following hierarchy: Course -> Module -> Chapter Here was the original EF LINQ statement: Course course = db.Courses .Include(i => i.Modules.Select(s => s.Chapters)) .Single(x => …

Read More