Is it possible to write queries in C# to connect to both the database Sql Server and MySql?

mysql , sqlserver , csharp , window India
  • 11 years ago
    Hi, I have one problem that I want to write queries once and want to use in both the database such as Sql Sever and MySql. Generally in Sql Server queries are written - select * from databasename.dbo.tablename and in MySql it is written - select * from databasename.tablename. But if I use select * from tablename its working fine. But , bcz I have to connect with two different database either in MySql or SqlServer. So, the problem arises. I want to make the software as database compatibilities. Thanx

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Before software should be reusable, it should be usable.” - Ralph Johnson