How do I add a reference to the MySQL connector for NET

Question

What does this mean  Next add reference to  MySql Data   actually I have downloaded mysql connector net  by following these instructions   First  you need to install the mysql connector net  it is located at  http   dev mysql com downloads connector net 1 0 html   Next create a new project  Next add reference to  MySql Data  Next add  using MySql Data MySqlClient    but im not able to install the connector   website http   bitdaddys com MySQL-ConnectorNet html

User · Accepted Answer

Add a reference to MySql Data dll  means you need to add a library reference to the downloaded connector  The IDE will link the database connection library with your application when it compiles   Step-by-Step Example  I downloaded the binary  no installer  zip package from the MySQL web site  extracted onto the desktop  and did the following    Create a new project in Visual Studio In the Solution Explorer  under the project name  locate References and right-click on it  Select  Add Reference   In the  Add Reference  dialog  switch to the  Browse  tab and browse to the folder containing the downloaded connector  Navigate to the  bin  folder  and select the  MySql Data dll  file  Click OK  At the top of your code  add using MySql Data MySqlClient   If you ve added the reference correctly  IntelliSense should offer to complete this for you

User · Answer

As mysql official documentation   Starting with version 6 7  Connector Net will no longer include the MySQL for Visual Studio integration  That functionality is now available in a separate product called MySQL for Visual Studio available using the MySQL Installer for Windows  see http   dev mysql com tech-resources articles mysql-installer-for-windows html    Online Documentation   MySQL Connector Net Installation Instructions

User · Answer

This is an older question  but I found it yesterday while struggling with getting the MySQL Connector reference working properly on examples I d found on the web   I m working with VS 2010 on Win7 64 bit but have to work with  NET 3 5     As others have stated  you need to download the  Net  amp  Mono versions  I don t know why this is true  but it s what I ve found works    The link to the connectors is given above in the earlier answers      Extract the connectors somewhere convenient    Open the project in Visual Studio  then on the menu bar navigate to Solution Explorer  View   Solution Explorer   and choose Properties  first box on the far left of the toolbar   The Solution Explorer shows up in the top right pane for me  but YMMV     In Properties  select References  amp  locate the instance for mysql data   It s likely to have a yellow bang on it  Yellow triangle with exclamation point in it    Remove it    Then on the menu bar  navigate to Project   Add Reference      Browse   point to where you downloaded the connectors   I have only been able to get the V2 version to work  but that may be a factor of my platform  not sure  Clean  amp  build your application   You should now be able to use the MySQL connectors to talk to your database  You can also now downgrade your  NET instance if you need to  we re constrained to  NET 3 5  but mysql data dll wants 4 0 at the time of my writing this    On the menu bar  navigate to the properties of your project  Project   Properties    Choose the Application tab   Target framework   Choose which  NET framework you want to use   You have to build the application at least once before you can change the  NET framework   Once you built once the connector will no longer complain about the lower version of  NET

User · Answer

In Visual Studio you can use nuget to download the latest version   Just right click on the project and click  Manage NuGet Packages  then search online for MySql Data and install

User · Answer

When you download the connector NET choose Select Platform    NET  amp  Mono   not windows

[.net] How do I add a reference to the MySQL connector for .NET?

Step-by-Step Example

Examples related to .net

Examples related to mysql