1. C# 4.0
2. Mysql-connector 6.3.9 For Visual Studio 2010
3. Visual Studio Student

Does any one know how to connect to MySQL 5.1 with Visual Studio 2010?

I have already tried the MySQL Connector/ODBC route and it got me really nasty results. The table rows were all listed as a view in the views section and nothing at all was listed in the tables or procedures folder.

Peter Mortensen

Greetings, I have installed MySql Connector 6.3.2 Beta. I am able to use the references of MySql.Data and MySql.Data.Entity. But i am not able to create a connection in DataBase browser tab in VS 2010. I am not able to get MySql Connector listed in Data Source list box in the add new. This is a limitation of the Express editions of Visual Studio. Dear MySQL Users, A new GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.1.1 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to.

jakejake

7 Answers

To get the Entity Frame working with VS2010, I had to do the following:

1. This only worked with Mysql .net Connector v6.3.1 (alpha). Previous versions ignored VS 2010 (click Development Releases)
2. I had to rename my Frameworkv1.1.4322CONFIG folder. Otherwise the install will fail. Rename it back when finished

(I've blogged about this here)

Update6.3.2 is in beta and I can confirm this works. (I didn't need to rename the framework folder)

Christian PayneChristian Payne

C# 4.0

this seems to solve the issue

UPDATED LINK TO LATEST RELEASE THANKS @Christian Payne

Update: looks like there is already a non-beta!!!!

LuiscencioLuiscencio

As someone else suggests..

..fixes the problem.

I had v6.2.3 installed after I had vs2010 installed and the MySQL driver was not shown in the list of the Database Connect dialog. I wrongly assumed I should use the .NET ODBC drivers instead and it caused all sorts of problems. Although I could easily connect to the DB using codebehind, the server explorer wouldn't connect to the DB.

Luckily after uninstalling 6.2.3 and installing 6.3.0 (from the link above) the MySQL driver was added to VS2010, and I was able to connect to the database and see it in my server explorer.

I was able to get this to work by doing the following:

My Environment:

• Development Box -- Win7 64bit,VS2010 Pro
• Deployment Box -- Win2k8 svr with IIS7running ASP.NET .Net 2.0/3.0/3.5 sp which ishosted at DiscountAsp.Net (Note:DiscountAsp.Net does not provide aMySQL DB when running on a Win2k8svr, I'm using a MySQL DB that I connectto elsewhere on the InterWebs)

Steps I took:

Mysql-connector 6.3.9 For Visual Studio 2010

1. Installed MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d
2. Ref'd the .Net 2.0 version of the MySQL assembly in my ASP.NET MVC2 Web project set to target .Net 3.5 (the path for the MySQL assemblies I used was C:Program Files (x86)MySQLMySQL Connector Net 6.3.6Assembliesv2.0)
3. I ref'd all 3 of the MySQL assemblies (MySql.Data.dll, MySql.Data.Entity.dll & MySql.Web.dll)
4. I marked each of those assemblies as 'Copy Local=True' in my project (a.k.a bin deployment)
5. Added a MySQL DB connection string to my Project (using the MySQL provider)
6. Added an ADO.NET Entity Data Model to my project in VS2010 using the connections string
7. VS2010 took about 30 secs to chew thru my MySQL DB schema but then provided me with a beautiful GUI interface to tweak my MVC Models
8. Used the DB Entities in my MVC controllers
9. Deployed the app to my hosted server at DiscountAsp.Net

It works like a charm :)

Erm... through code? Or do you mean the server explorer add-in? Have you tried the latest (albeit GPL-ed) connector version for .NET from Mysql themselves? Again, it's GPL-ed so be aware of the consequences of using that for your own software.

Frans BoumaFrans Bouma

Microsoft Visual Studio 2010 Beta 2 is busted for DDEX providers. They are auto promoting a VS 2008 assembly from 9.0 to 10.0 and it fails. The failure has to do with the fact that a .NET 2 assembly cannot load a .NET 4 assembly.

This worked in beta 1, so it is something they broke.

I even went back and tried the reference DDEX provider from the SDK. It won't load in VS 2010 beta 2 either. That tells me they have something that needs to be fixed.

When is the next beta?

Visual Studio Student

Peter Mortensen

protected by Community♦Oct 3 '11 at 15:56

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged mysqlvisual-studio-2010 or ask your own question.