Elegant Data Access Strategies in .NET
Thanks to ADO.NET, database access and management has never been easy and a breeze. We have high speed managed providers without much of resource consumption. All resource management are being managed by CLR.
The default support of database access in .NET is like
- Generic OLEDB
- Generic ODBC
But it would be a better strategy for us to have a Data Access Layer, which is shortly known as DAL in programming world, which would have the complete onus in talking to the database and returning the results, instead of having each of our modules talk to the database. This way, in future,if wanted to make some performance improvements to the database access, the changes are restricted to one particular area instead of having this spill out through out the application.
Perhaps, I would like to recommend to the readers, the following URLs which we researched upon in Database Access Layers. We also have our own GDN (GotDotNet) Workspace. If you are interested to contribute some effort, please do drop in.