Designing DAL in .NET to be "data-source independent" and not just "database independent" ?
- by Munish Goyal
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'.