Data Access in the Commons Library

The data access block in the Commons Library is based on the Unit of Work and Repository patterns – or at least my take on them.

Unit of Work

You start with a unit-of-work factory (which is an implementation if IUnitOfWorkFactory) and call Create on it to get an instance of IUnitOfWork which is also IDisposable. So, you get a unit-of-work and do your business inside a using block, and call Commit before you leave the block. Methods inIUnitOfWork are all based on working with a specific entity type (which is just a POCO with an identifier field) and uses LINQ and IQueryable – makes it easy to use as a consumer, but also makes it easy to implement providers as most providers worth their salt already have a LINQ interface. As of the time of this writing, I’ve written two providers – one based on Fluent NHibernate and one based on MongoDB.

The unit-of-work factory is where the DB configuration and initialization takes place. All settings are retrieved from the commons library configuration block. You can use multiple providers and give them different names. You can then access each factory using a MEF imported instance ofIAppDataAccess which lets you access it like a dictionary with the key being the name you used during configuration.

So, given an instance of IAppDataAccess called, say, appDataAccess and assuming you have a provider configured with the name “MyDB”, a typical unit-of-work operation looks as follows:

using (var unit = appDataAccess["MyDB"].Create())
    // ... Do your thing on "unit".



As far as repositories are concerned, they’re light-weight wrappers around a unit-of-work tailored for a specific entity. Given an entity Foo with an integer identifier, you would have an IFooRepository that is essentially just IRepository<Foo, int> implemented by a FooRepository that isRepositoryBase<Foo, int>. You can, of course, extend it with other methods to implement different queries and such – but I rarely find the need, and I prefer such logic live in the services. Thus, repositories become more of a convenience than anything else – in my applications, I auto-generate all repositories using my Modeling Kit.

Technical details can be found in the Data Access section here. As usual, feedback and suggestions for improvement are most welcome.


One thought on “Data Access in the Commons Library

  1. Pingback: Finance Manager | Aashish Koirala

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s