using multiple databases

[dizyn]

Hi ....

I am new to asp.net and i want to use multiple types of dtatbases in my web application.
Means i want to use MySql and MsSql. my user will select which databse its going to use.
My system will support both databases and will use one of them at a time.
i need something generic where i don't need to write seprate queries.

any help
thanks
dizyn

 

[Paszt]

What exactly is the question?

With ADO.NET the classes are writen in such a way as to make them fairly generic. In some simpler cases you could simple change the connection string to change to a different database/database type. The problem is that MySQL and MsSQL use somewhat different SQL syntax.

 

[jwh]

Yeah, you may end up having to release 2 versions, to support the different database engines.

I assume you are not using a data access layer?