Override class objects

[Denster]

I am using VB.Net to produce a website with database access. I would like to cater for a number of databases such as sqlServer, Mysql, Oracle etc... Ideally I want to have a data access class for each type of database which would have identical functions. Then have something in the web.config file to tell the application which class to use. I think this will then need some kind of provider class to retrieve the required information from the web.config and act as a link between the logic layer and the data access layer. Am I on the right lines? and if so how do I go about the provider class.

 

[jmeckley]

the best approach is to use a tool that already solved the data access problem. Nhibernate is a solid OSS project with a great user base on google groups. there are other as well ActiveRecord (also OSS), LLBL Gen Pro ($). those are the big 3.

if this isn't an option use the System.Data.Common.DbProviderFactories.GetFactory() to manage your polymorphism. using the connectionstring node in the configuration file and ConfigurationManager you can build db agnostic code. the one catch is you need to ensure your sql statments translate across all databases.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190