Designing DAL in .NET to be "data-source independent" and not just "database independent" ?

Posted by Munish Goyal on Stack Overflow See other posts from Stack Overflow or by Munish Goyal
Published on 2011-01-04T09:40:37Z Indexed on 2011/01/04 9:54 UTC
Read the original article Hit count: 301

Filed under:

data-access-layer

How to design such flexible DAL (specifically in .NET) ?

What interfaces .NET provides and what should be done on my own ?

Its a greenfield project starting with SQL Server as data source but in future, parts of it will move to different NoSQL type of datastores.

Also, we may need to experiment with lot of different datastores (like some data may have to go with Cassandra, some with RDBMS, some to other DHT etc.)

Therefore easily switchable access layer will be needed. All i know right now is the 'data' and 'operations needed on that data'.

Related posts about data-access-layer

Looking for a .NET data access layer

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am looking for a data access layer for ado.net. I am not interested in linq, EF, NHibernate or any other ORM. Currently, I am using the data access layer from umbraco. The DAL is very good but they stopped developing it so i am looking for a different one. Does anyone know where I can find… >>> More
Recommend .NET data access layer/middle tier

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm currently creating an MVC application that will likely to expand to include a silverlight, wpf and possible windows phone all using the same data. So I've created a class library to keep all my objects in and I've created the MVC app. My question is what would be the best way to access… >>> More
Data Access Layer with Enterprise Library in Mobile Applications

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I use Enterprise Library to do a Data Access Layer in c# for Sql CE and .NET Compact Framework? I haven't found clear examples. I would like to learn Enterprise Library but any example will be appreciated. >>> More
Developing your Data Access Layer with ADO.NET Entity Framework 4

as seen on Simple Talk - Search for 'Simple Talk'
Entity Framework has evolved in the light of feedback. ADO.NET Entity Framework 4 is now better able to accommodate different development methodologies. A welcome improvement is the way that, the application designer now has a range of options in the way that Entity Framework creates the Data Access… >>> More
How to Use CslaGen to Generate CSLA Data Access Layer Code

as seen on Code Project - Search for 'Code Project'
This article shows how to quickly create the CSLA DAL files for a mother/daughter relationship (hierarchical data) using CslaGen. >>> More

Developer IT