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

• • Reply

  11 years ago

  by pradeepfusion

  pradeepkumar pandit

  Pune, India

  Joined 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
  Report abuse