In DAL, the Repository vs. Service design is used by EF and Dapper.

asp.net-mvc dapper design-patterns entity-framework

Question

I'm working on project and I need to design the DAL. I will be using Entity Framework for most of the project and Dapper for some performance-sensitive areas.

I was thinking about using the Repository pattern but then EF already implements this pattern in some sense. But that's not the case with Dapper. Then I am wondering is it valid to mix Repository and Service patterns in my DAL? Or would this be crossing into the Business Logic Layer?

A sample structure I was thinking to buid:

MyProjectName.Main
    Views/
    Controllers/
    Infrastructure/
    ...
MyProjectName.DAL
    DataService.EF/
        fileName.cs
        ...
    DataService.Dapper/
        fileName.cs
        ...
1
12
11/5/2013 6:35:44 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

EF or any other ORM doesn't implement the Repository. The Repository is meant to decouple the Domain from the Persistence. Domain works with domain objects, EF/Nhibernate/Dapper etc work with persistence entities which represents an OOP view of the relational database.

See the difference? One needs business objects, the other deals with data structures. They are similar but they are not the same. Domain models concept, behavior and use cases, Persistence cares about storing data so that is fast retrieved. Different responsibilities. The Repository acts as mediator between them, "converting" Domain objects in persistence structures and vice verse.

Always, the ORM is a implementation detail of the Repository. For CRUD apps, where you don't really have a Domain you're dealing directly with the db i.e the (micro)ORM. In that case the Repo makes sense only as a facade to give some business meaning to data access ( GetOrders is much easier to understand that a whole Linq or 5 lines SQL joining 3 tables).

The Repository interface is defined where it's needed, but it's implemented in Persistence (DAL). Same with Services,they can be defined (as an interface) in the Domain while their implementation can be in DAL. While Repository implementation almost always is part of DAL, only some Services reside in DAL, for the simple reason that it's easier for them to do their job that way. Other Services can directly use repositories (injected usually via constructor) and don't touch the DAL.

Whatever pattern you use, try to understand their actually purpose and always think about decoupling.

8
2/9/2014 5:39:23 PM

Popular Answer

Check out an EF + Dapper Hybrid Implementation that Bradley Braithwaite has created.

GitHub Repo: https://github.com/bbraithwaite/HybridOrm

Accompanying Blog Post: ORMs: Don't Reinvent the Wheel

In terms of structuring the Project Layers to avoid "bleeding", here's how he did it.

Project Layout

From Blog Post: Creating Data Repository Using Dapper

Shiva

Related Questions

With Moq, unit test the EF Repository pattern.

I decided to start writing unit tests in our application. It uses Entity Framework with a repository pattern....Now I want to start testing logic classes which are using the repositories. I provide a simple example here....Three of my methods in the class GenericRepository:...public class GenericRepository : IRepository { public IQueryable<TEnt...
entity-framework moq repository-pattern unit-testing
asked by John

EF 4: Using MVC and the repository approach to appropriately update objects in DbContext

it somehow messes up the ChangeTracker's ability to report on the changes...No it doesn't messes anything. Change tracker ability is based on the fact that change tracker knows the entity prior to making changes. But in your case the change tracker is informed about the entity with changes already applied and POCO entity doesn't keep any informatio...
asp.net-mvc-3 c# entity-framework
asked by Ladislav Mrnka

NOT using repository pattern, use the ORM as is (EF)

I've gone down many paths and created many implementations of repositories on different projects and... I've thrown the towel in and given up on it, here's why. ...Coding for the exception...Do you code for the 1% chance your database is going to change from one technology to another? If you're thinking about your business's future state and say ye...
aop architecture design-patterns entity-framework repository-pattern
asked by Ryan

Unit of Work with Repository Pattern MVC 5 & EF 6

It's not perfect to implement UnitOfWork as a static class. Define an interface IUnitOfWork. Your db context will implement this interface. It may look like:...public interface IUnitOfWork { int SaveChanges(); } public class EFDbContext: DbContext, IUnitOfWork { public DbSet<User> User { get; set; } public EFDbContext(string connect...
asp.net-mvc c# entity-framework repository-pattern unit-of-work
asked by tabalin

Entity Framework - CreateQuery VS ExecuteFunction VS ExecuteStoreQuery VS ExecuteStoreCommand

Very similar to ...CreateQuery... would be following:...var id = 42; using(var ctx = new Entities()){ var query = ctx.Companies.Where(o=>o.Id==id); var result = query.First(); } ...Before I call First() query is just a query. Nothing has been sent to the database. Only when data is asked will the query get executed and data retrieved. ...Writin...
c# difference entity-framework executestorequery
asked by Margus

Service layer and project structure in ASP.NET MVC 5 without repository and UoW patterns

There is no reason to use a Unit of Work pattern with Entity Framework if you have no need to create a generic data access mechanism. You would only do this if you were:...using a data access technology that did not natively support a Unit of work pattern (EF does)...Wanted to be able to swap out data providers sometime in the future.. however, thi...
asp.net-mvc asp.net-mvc-5 entity-framework entity-framework-6 service-layer
asked by Erik Funkenbusch

N-Tier Architecture with MVC4 EF and Repository Pattern

In addition to the adv. and disadv. (...http://www.codeproject.com/Articles/430014/N-Tier-Architecture-and-Tips#nAdvantages...) are defined for N-tier I will cover few points based on my recent experience with similar architecture:...Benefits are:...Since controllers are thin layered and Business Logics are stored in Actual Services, you can share ...
asp.net-mvc-4 design-patterns entity-framework-6 n-tier-architecture repository-pattern
asked by codebased

EF6, Unit of Work and Repository Pattern - Is this the wrong pattern for a sync service?

Doesn't bother me, I only use SO and don't intend to go anywhere else, and don't mind having questions like these on SO....I would highly recommend that your service as for ...IRepository... and your repository ask for ...IUoW.... I even like to think of ...IRepository... as more than just a barrier to EF. I normally only use a repository if either...
c# entity-framework-6 repository-pattern unit-of-work
asked by Michal Ciechan

EF How to query more entities with .include() and using repository pattern

I have found a work around for this problem. The main challenge here is to filter in a nested SQL query. I could not find a solution with .include(). Especially my current work environment in which we are useing repository pattern wouldn't allow me to filter within includes like:...var res = await this._exampleStoneCatalog.Query().include(x => x.Ex...
c# entity-framework entity-framework-6 linq repository-pattern
asked by Marc Ottenbacher

In SQL Server, Entity Framework 6 vs. Dapper vs. stored procedures vs. requests

Code using EF exhibiting performance issues will not magically run faster with Dapper or ADO + Sprocs. To get to the bottom of the performance problem you need to investigate and eliminate the causes of the performance issues....At the top level, these performance issues stem from two core problems....Loading too much data....Loading data too often...
dapper database entity-framework linq sql-server
asked by Steve Py

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow