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

by

“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:

  1. Create a new project in Visual Studio
  2. In the Solution Explorer, under the project name, locate References and right-click on it. Select “Add Reference”.
  3. 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.
  4. 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.

More Related Contents:

  1. How can I use a MySql User Defined Variable in a .NET MySqlCommand?
  2. Unable to convert MySQL date/time value to System.DateTime
  3. How to insert a very large number of records into a MySql database as fast as possible
  4. Why does Math.Round(2.5) return 2 instead of 3?
  5. When should I use a struct instead of a class?
  6. What are Extension Methods?
  7. ResourceDictionary in a separate assembly
  8. How to populate a WPF grid based on a 2-dimensional array
  9. How do I fix the Visual Studio compile error, “mismatch between processor architecture”?
  10. Bind to a method in WPF?
  11. When should I deploy my assemblies into the GAC?
  12. NetworkStream.ReadAsync with a cancellation token never cancels
  13. How can I make a single event handler handle ALL Button.Click events?
  14. How do you configure WCF known types programmatically?
  15. Get path to execution directory of Windows Forms application
  16. Marshalling a big-endian byte collection into a struct in order to pull out values
  17. .NET 4.0 build issues on CI server
  18. How to get Uri.EscapeDataString to comply with RFC 3986
  19. How to prevent XPath/XML injection in .NET
  20. What is the difference between app.config file and XYZ.settings file?
  21. HttpClientFactory.Create vs new HttpClient
  22. Regular expression for parsing links from a webpage?
  23. Change Assembly Version in a compiled .NET assembly
  24. PowerShell generic collections
  25. How do I find out which control has focus in .NET Windows Forms?
  26. Linq to Objects: does GroupBy preserve order of elements?
  27. What happens if I remove the auto added supportedRuntime element?
  28. Drawing Pixels in WPF
  29. Opening XPS document in .Net causes a memory leak
  30. Does Console.WriteLine block?

Leave a Comment