Archive

Archive for the ‘Entity Framework’ Category

Entity Framework with Stored Procedures?

November 18, 2013 Leave a comment

I found this study/quote interesting:

“We’ve carefully evaluated whether object-relational mapping (ORM) tools such as the Entity Framework could help us achieve simpler and more testable code without moving away from stored procedures. Our conclusion was that the Entity Framework is an extremely appealing solution, but it relies heavily on being able to compose and execute complex SQL statements at run time. It can map stored procedures, but when limited to mapping only stored procedures, it loses most of its benefits. For that reason, we decided to implement our own database-access framework as an adaptive database access layer.”

From the article:

Adaptive Access Layers + Dependency Injection = Productivity

Advertisements