Link to home
Start Free TrialLog in
Avatar of toooki
toooki

asked on

Connect to MySQL via C# .NET (Visual studion 2008)

Which client library can we use to connect to a MySQL 5.0 database from MS .NET Visual Studio 2008 code?

I use
using System.Data.OracleClient;;
using System.Data.SqlClient;

for Oracle and SQL server databases respectively.

SOLUTION
Avatar of Dirk Haest
Dirk Haest
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of toooki
toooki

ASKER

Thank you.
I am going to check the details you sent to me.
You can try OleDbConnection class:
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection(v=vs.80).aspx

This way will allow you to connect to any of the most common databases by just changing the connection string.

The following website can help you to determine the appropriate connection string:
http://www.connectionstrings.com
Avatar of toooki

ASKER

Thank you. I am going to check this.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of toooki

ASKER

Thanks srosebabu. I am going to try this soon.