Using Sql and OleDB

[Steven Blair]

Hi,

I have a class which uses SQL object to connect and return data from the
database.

I want to upgrade the functionality of this dll so it can use OleDB.

Should I stick with my current SQl class and add OleDB fucntionality in it,
ie overload methods like MyConnect() or should I write a seperate class and
the suer is then responsible for creating the correct class ?

--
Steven
www.stevenblair.com

[William Ryan]

Extending the class would give you an easy way to add this functionality and
still retain the 'look and feel' of it which is probably being referenced
from all over your project. Another approach would be to implement a
factory pattern wherein the class is responsible for creating the objects...
http://www.vbdotnetheaven.com/Code/Jun2003/2043.asp

HTH,

Bill
"Steven Blair" <st**********@btinternet.com> wrote in message
news:bu**********@sparta.btinternet.com...

Hi,

I have a class which uses SQL object to connect and return data from the
database.

I want to upgrade the functionality of this dll so it can use OleDB.

Should I stick with my current SQl class and add OleDB fucntionality in it, ie overload methods like MyConnect() or should I write a seperate class and the suer is then responsible for creating the correct class ?

--
Steven
www.stevenblair.com