6 posts about Data Access Component by 3 contributors.
Know Data Access Component? Share what you know with developers who are learning it.
Here is one more flexible approach to achieve the same. I prefer this approach to generic data access.
The article A Generic Data Access Component using Factory Pattern provides a very good way of creating ADO.Net data provider independent applications, but there is one problem with it. Different ADO.Net data providers use different approaches in labeling of parameters in SQL statement.
I've received couple of emails people asking me how can they use a common data provider to access various types of data sources without loosing the power and flexibility of native data provider libraries.
This article shows to utilize the System.Activator class and a factory pattern to create the concrete provider classes.
The attached source code a data access component for SQL Server that contains methods to get a DataSet.
Easy way to Writing a Generic Data Access Component, to utilize the System.Activator class and a factory pattern to create the concrete provider classes as was pointed-out in Dan Fox's article Design an Effective Data-Access Architecture (.netmagazine, vol. 2, no. 7).
DevSocialUpcoming · 3rd editionAI Agents ConferenceNov 23–27, 2026Live onlineMembers only16days leftRegisterPublish an article in this category and earn +1,000 SHARP when it is approved.
Write an article