Click here to Skip to main content
13,505,493 members
Click here to Skip to main content
Add your own
alternative version

Tagged as


40 bookmarked
Posted 25 Nov 2008

In memory data access, a methodology to simplify agile development

, 25 Nov 2008
Rate this:
Please Sign up or sign in to vote.
An article on architecting application layers to separate concerns and, particularly, data access.



Object oriented design concepts and agile development principles state that data access is a detail and not part of the domain of the application model. This means that the architecture of applications should ensure that the implementation of object persistence and retrieval is hidden from the domain of the application model.

With the complete decoupling of the data access layer comes the possibility to test the business model in isolation by providing a data access layer that mimics a real one but doesn't carry the entire heavy infrastructure needed by an RDBMS and the code to access it.

A possible way to simulate a data access layer is to use mock objects. This article proposed a slightly different approach that consists of implementing a simple "in memory" data access and persistence mechanism. This approach allows deferring the development of the database details, typically involving implementing table structures, SQL generation scripts, SQL queries, and other configurations.

But, how do we obtain a complete separation of the data access layer?

Dependency Inversion

The Dependency Inversion Principle, as Robert C. Martin stated in "Agile Principles, Patterns, and Practices in C#", says that:

  • High level modules should not depend upon low level modules. Both should depend upon abstractions.
  • Abstractions should not depend upon details. Details should depend upon abstractions.

Dependency inversion separates concerns, and enables a top-down developing process, building high level modules before low level modules.

.NET Implementation

Applied to the .NET world, dependency inversion implies that:

  • The DAL (data access layer) should be in a separate assembly.
  • The business logic layer and the DAL should depend upon common interfaces defined in a third assembly.
  • The DAL shouldn't have the responsibility of instantiating objects, the business logic layer should.

The diagram at the beginning of the article shows the architecture of this solution for layer separation. We have four assemblies:

  • Entities: Holds the definition for the entities in the application model. It doesn't reference any of the other assemblies.
  • Logic: Contains the application business rules (object creation included). It references Entities and Interfaces.
  • Interfaces: Contains contracts for low level modules, data access, in our case. It references Entities.
  • Data Access: Provides services for persisting and retrieving objects. It references Entities and Interfaces.

The code included in this article provides a Test project.


The sample provided is about business order management. Here is the class diagram that represents the entities in the sample:



The separation we are looking for can be obtained by applying the Abstract Factory and Facade patterns through the definition of a group of interfaces, one for each entity class, wrapped together by an interface adding connection and transaction management. As in the following class diagram:


The IOrdersSession interface will orchestrate the data access functionality provided by all the single entity data access classes.

public interface IOrdersSession: IDisposable
    IDbTransaction BeginTransaction();

    ICustomerDAL DbCustomer { get; }
    void Save(Customer customer);
    void Delete(Customer customer);

    IOrderDAL DbOrder { get; }
    void Save(Order order);
    void Delete(Order order);

    IOrderItemDAL DbOrderItem { get; }
    void Save(OrderItem orderItem);
    void Delete(OrderItem orderItem);

    IProductDAL DbProduct { get; }
    void Save(Product product);
    void Delete(Product product);

This interface derives from IDisposable to ensure that any database connection is closed (and transaction rolled back, if still present) at object disposal, and to enable the use of the using statement.

This is the code for the Order entity data access interface:

/// method to call to instantiate objects
public delegate Order OrderDataAdapterHandler(Guid id, Guid idCustomer, 
                                              DateTime orderDate);

/// <summary>
/// Order data access interface
/// </summary>
public interface IOrderDAL
    List<Order> Search(Guid id, Guid idCustomer, DateTime? 
                             orderDate, OrderDataAdapterHandler orderDataAdapter);

A callback mechanism is used to instantiate objects off the data access layer. A delegate, OrderDataAdapterHandler, is passed as a parameter in the methods that retrieve objects (the search method, in our example). A blog post by Scott Stewart is available for detail info about this alternative to using DTOs to retrieve data from the DAL.


The business logic classes shouldn't have a direct reference to the DAL classes. Instead, they will reference the IOrdersSession interface, and a Dependency Injection (DI) mechanism will provide the actual object implementing it.

Dependency injection can be provided by a DI framework (such as NInject or Unity) or, as in the sample code here quoted, by a simple method that instantiates an object implementing IOrdersSession. In this case, this is done in a conditional way: business logic classes decorated with the [InMemoryDAL] attribute will be injected with the InMemory access classes.

public class InMemoryDALAttribute : System.Attribute { }

public class GBDipendencyInjection
    public static IOrderdSession GetSession()
        // get call stack
        StackTrace stackTrace = new StackTrace();

        // get calling class type
        Type tipo = stackTrace.GetFrame(1).GetMethod().DeclaringType;

        object[] attributes;

        attributes = tipo.GetCustomAttributes(typeof(InMemoryDALAttribute), false);

        if (attributes.Length == 1)
            return new InMemoryOrderSession();
            return new SqlServerOrderSession();

Methods that need to retrieve data will instantiate IOrderSession in a using statement, and pass as a parameter a factory method with a signature corresponding to the one defined in the entity DAL interface.

public List<Order> GetByCustomerId(Guid customerId)
    List<Order> lis;
    using (IOrdersSession sess = GBDipendencyInjection.GetSession())
        lis = sess.DbOrders.Search(Guid.Empty, customerId, null, CreateOrder);
    return lis;

In the OrderLogic class, CreateOrder is the factory method that instantiates objects of type Order.

public Order CreateOrder(Guid id, Guid idCustomer, DateTime orderDate)
    Order order = new Order();
    CustomerLogic costumerLogic = new CustomerLogic();
    Customer customer = costumerLogic.GetById(idCustomer);
    if (customer == null)
        throw new ArgumentException("Customer not found.");
    order.Customer = customer;
    order.OrderDate = orderDate;
    return order;

In Memory Data Access

A singleton class contains a generic list of objects whose storage is simulated. Since it is a singleton, it maintains the list across threads, thus it can be still used when developing the interface (even a web interface) and defer database development in the last stages of development. A cascading find method is applied to search the list.

public sealed class OrderInMemoryDAL : IOrderDAL
    internal List<Order> OrderList;

    static readonly OrderInMemoryDAL _istance = new OrderInMemoryDAL();

    private OrderInMemoryDAL()
        OrderList = new List<Order>();

    internal static OrderInMemoryDAL Istance
        get { return _istance; }

    #region IOrderDAL Members

    public List<Order> Search(Guid id, Guid idCustomer, 
           DateTime? orderDate, OrderDataAdapterHandler orderDataAdapter)
        List<Order> lis = OrderList;
        if (id != Guid.Empty)
          { lis = lis.FindAll(delegate(Order entity) { return entity.Id == id; }); }
        if (idCustomer != Guid.Empty)
          { lis = lis.FindAll(delegate(Order entity) 
            { return entity.Costumer.Id == idCustomer; }); }
        if (orderDate.HasValue)
          { lis = lis.FindAll(delegate(Order entity)
            { return entity.OrderDate == orderDate; }); }

        return lis;


InMemoryOrderSession implements IOrdersSession, managing saving and deleting simply by adding and removing from the generic lists stored in the singleton objects.

public class InMemoryOrderSession: IOrdersSession
     public IOrderDAL DbOrders
        get { return OrderInMemoryDAL.Istance; }

     public void Save(Order order)

    public void Delete(Order order)
        OrderInMemoryDAL.Istance.OrderList.RemoveAll(delegate(Order _entity) 
                         { return _entity.Id == order.Id; });


This approach enables to develop the model and even the user interface without worrying about the database details. This lowers the cost of changes to the model since it is not required to change database structures and SQL scripts and queries.

Another advantage is being able to test the business logic in isolation from the database access code.

The last stage of the development of our application will be writing a class implementing IOrdersSession that makes use of an RDBMS through an access library, like ADO.NET, providing connection and transaction services. This class will be a facade for all the single classes that manage CRUD operations on the RDBMS for model entities persistence.

The next step will be removing the [InMemoryDAL] attribute from the business logic class. Now, the simple DI mechanism will inject the "real" DAL in the application. Running Unit Tests on the business logic classes again, the DAL will be tested.

In the following article, Building an Agile SQL Data Access Layer, I focus on the development of the code needed for SSL Server data access, with sample code extending the one attached to this article.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software architect. At present working on C# development, with mainly Ajax and MVC user inteface. Particularly interested in OOP, test driven, agile development.

You may also be interested in...


Comments and Discussions

QuestionThe Best Pin
Member 45586617-Sep-12 4:16
memberMember 45586617-Sep-12 4:16 
GeneralMolto Bene Giorgo Pin
RS29013-Feb-09 15:06
memberRS29013-Feb-09 15:06 
GeneralVery good article Pin
Donsw16-Jan-09 6:59
memberDonsw16-Jan-09 6:59 
GeneralThank you for article. Pin
SpLove27-Nov-08 4:58
memberSpLove27-Nov-08 4:58 
GeneralRe: Thank you for article. [modified] Pin
Giorgio Bozio27-Nov-08 5:21
memberGiorgio Bozio27-Nov-08 5:21 
GeneralRe: Thank you for article. Pin
SpLove27-Nov-08 21:20
memberSpLove27-Nov-08 21:20 
GeneralRe: Thank you for article. Pin
Giorgio Bozio27-Nov-08 23:44
memberGiorgio Bozio27-Nov-08 23:44 
GeneralRe: Thank you for article. Pin
SpLove28-Nov-08 5:37
memberSpLove28-Nov-08 5:37 
GeneralRe: Thank you for article. Pin
Giorgio Bozio28-Nov-08 5:44
memberGiorgio Bozio28-Nov-08 5:44 
GeneralRe: Thank you for article. Pin
O1eg Smirnov30-Nov-08 9:35
memberO1eg Smirnov30-Nov-08 9:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.180417.1 | Last Updated 25 Nov 2008
Article Copyright 2008 by Giorgio Bozio
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid