> -----Original Message----- > From: Joel Mueller [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 30, 2002 5:30 PM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] How are you supporting multiple DB vendors? > > > We have an abstract base class for the data access layer, which has a > static Create method that determines which concrete subclass to return > based on the database type specified in a configuration file. Each > concrete subclass talks to a particular database type as natively as > possible, using stored procedures and the appropriate *Connection > objects and such. In the business layer, we can just do something like > CustomersDB.Create() to get back the appropriate database-specific > subclass, without having to know what that subclass is.
Have you found any variation in invoking stored procedures accross DB vendors? If so how do you select the right strings? Or does populating a OleDbCommand with parmaater objects handle it? Do you use the OleDbCommand.CommandText property? Jim You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
