7 posts about Generic Data Access Component by 3 contributors.
Know Generic Data Access Component? Share what you know with developers who are learning it.
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.
This article shows to utilize the System.Activator class and a factory pattern to create the concrete provider classes.
ADO.NET library provides different types of data providers to work with different data sources. Three common data providers are OLE DB, SQL, and ODBC. The main reason of using different data providers to maintain the performance and not loose native data provider functionality.
ADO.NET library provides different types of data providers to work with different data sources. Three common data providers are OLE DB, SQL, and ODBC. The main reason of using different data providers to maintain the performance and not loose native data provider functionality.
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).
OK, 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.
Another way to solve this problem is 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