using multiple databases

dizyn

New member
Joined
Jul 28, 2006
Messages
1
Programming Experience
Beginner
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

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
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

Well-known member
Joined
Aug 18, 2006
Messages
155
Programming Experience
3-5
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?
 
Top Bottom