Create a Vendor-Independent Data Access Class

Vendor independent or provider agnostic data access is a relatively easy thing to implement, thanks to the structure of ADO.NET. You’ll find the classes you’d need in the System.Data.Common namespace.

To access data without knowing the provider type, you’d start in your web.config, by adding these entries to it:

<connectionStrings>
                <add name=”theString” connectionString=”your string here” providerName=”System.Data.SqlClient”/>
</connectionStrings>
<appSettings>
                <add key=”select” value=”SELECT * FROM Customers”/>
</appSettings>

Then in your data access class, you should define a DBProviderFactory, create an instance of it by calling the GetFactory static method passing the provider type as parameter (defined in your web.config). Then you should create a DBConnection class and a DBCommand class, or anything else you’d need, and use it as if you’d use for example the SQL classes. Example:
Continue reading “Create a Vendor-Independent Data Access Class”

Advertisements