How to work with mysql in C# ?

Question

my visual studio 2008 don't know "MySql.Data.MySqlClient" and says: "The type or namespace name 'MySql' could not be found (are you missing a using directive or an assembly reference?)"

what should I do now?

Answer 1

I suppose you need Connector/Net

http://dev.mysql.com/downloads/connector/net/5.2.html

Connector/Net is a fully-managed ADO.NET driver for MySQL.

Here're some guides

http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=576

http://www.primaryobjects.com/CMS/Article68.aspx

http://stackoverflow.com/questions/359880/how-do-i-set-up-mysql-to-work-with-c

Answer 2

.NET Framework Data Providers (ADO.NET)

Connecting to MySQL database from your .NET applications.

Connector/Net AND How to connect to MySQL 5.0. via C# .Net and the MySql Connector/Net

Answer 3

You should add a reference to "MySql.Data.dll" in your Visual Studio 2008 project via rightclick/add reference.

The MySql.Data.dll should be part of the .Net MySql connector which is available here. And there is a kind of tutorial for MySQL and C# too.