asked on

Net platform connection for MySQL

I am wondering if there is a special Net connection for Mysql which can be used as a class in C# or ASP.Net.

I mean a connection tailored for MySQL and not a generic one.
Ideally I would also like a tutorial that shows how to install such a connection.

Thanks

Dave Baldwin

Here are the MySQL connectors: http://www.mysql.com/products/connector/ A number of people have found the ODBC connector easier to use.

adamtrask

ASKER

Thank you Dave,
Does it need to be installed in a special way?
I will also assume that once it's installed I treat it like a class, the same way I would use ODBC, correct?

Dave Baldwin

You need to download the .NET code and look at the directions. The ZIP file contains 811 files of source code, images, and other stuff. It becomes part of your project I believe.

ODBC connectors (drivers) must be installed so they will show up in Windows Data Sources.

adamtrask

ASKER

I downloaded the Net connection and it only had an installation file - no zip.
I ran it nonetheless but have no idea what driver it placed in my Visual Studio 2010.

Visual Studio 2010 comes with ODBC already installed, and I was expecting a different driver for MYSQL, one tailored for it , the same way SQLClient is optimized for MS SQL Server.

adam

ASKER CERTIFIED SOLUTION

Dave Baldwin

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

adamtrask

ASKER

Thank you Dave for the explanation.
I was under the impression that ODBC was a class that provided all the required routines for connection to MySql.