How to connect to a MySQL Data Source in Visual Studio

Question

I use the MySQL Connector/Net to connect to my database by referencing the assembly (MySql.Data.dll) and passing in a connection string to MySqlConnection. I like that because I don't have to install anything.

Is there some way to "Choose Data Source" in Visual Studio 2010 without installing something?

How can I get a MySQL option (localhost) to show up on one of these lists? Or do I have to install something?

(I don't want to use ODBC btw)

"Add Connection" from Server Explorer: alt text

Entity Data Model Wizard: alt text

score 35 · Answer 1 · answered Nov 20 '10 at 23:19

35

install the MySQL .NET Connector found here http://dev.mysql.com/downloads/connector/net/

alt text

answered Nov 20 '10 at 23:19

Jon Black

15,289
5
40
41

Thanks, but I am familiar with the link to that driver! – JohnB Nov 20 '10 at 23:58
@JohnB then what's the problem? f00's screenshot shows that MySql appears as an option in the "Choose Data Source" dialog. – Lucas Nov 21 '10 at 00:16
@Lucas, no I get that, my question was whether is was possible to Add a Connection through the Server Explorer by just using the `MySql.Data.dll` assembly. @f00: +1 for your help. – JohnB Nov 22 '10 at 16:53
@JohnB Oops, I misread, though you meant it didn't show up for you. I'll add an answer with details, for future reference :) and +1 f00 – Lucas Nov 23 '10 at 14:48
See my post below - it seems you may need to install older drivers for VS2010!! – stuzor Feb 07 '14 at 22:57
I did the same, along with the standalone installer for VS (https://dev.mysql.com/downloads/windows/visualstudio/), restart Visual Studio 2017 and there were the driver ready to use. It did not appear on VS2019, though. – Chesare Aug 26 '19 at 10:14

Memet Olsen · Answer 2 · 2018-02-05T10:34:54.150

27

"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."

Source: http://dev.mysql.com/downloads/connector/net/6.6.html

edited Feb 05 '18 at 10:34

answered Jan 05 '14 at 22:08

Memet Olsen

4,438
5
36
49

score 11 · Answer 3 · edited Jun 20 '20 at 09:12

After a lot of searching and trying many solutions, I got it finally:

uninstall connector
uninstall MySQL for Visual Studio from control panel
reinstall them according to the table below
copy the assembly files from C:\Program Files (x86)\MySQL\MySQL Connector Net 6.9.8\Assemblies\v4.5 to C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE
log off and reopen your solution
enjoy

score 8 · Answer 4 · edited May 23 '17 at 12:18

8

This seems to be a common problem. I had to uninstall the latest Connector/NET driver (6.7.4) and install an older version (6.6.5) for it to work. Others report 6.6.6 working for them.

See other topic with more info: MySQL Data Source not appearing in Visual Studio

edited May 23 '17 at 12:18

Community

1
1

answered Jul 21 '13 at 18:05

stuzor

1,846
1
24
33

2

Had a similar experience. MySQL wouldn't show in the Data Sources list using Connector/NET 6.7.4. Version 6.6.5 was fine though. – mkataja Aug 19 '13 at 09:15
THANK YOU MKATAJA AND SERGIO!!!!!!! Uninstalling my current MySQL Connector from Control Panel, installing 6.6.6, relaunching VS worked perfectly! Thank you!! – Subby Dec 22 '13 at 21:10
2

Starting version 6.7, Visual Studio integration was splitted into a different product, MySql for Visual Studio, see http://dev.mysql.com/downloads/windows/visualstudio/ – Fernando Gonzalez Sanchez Jul 15 '14 at 01:39
Thanks! I installed the most recent version of SqlConnector and it didn't work for VS2010. Installed 6.6.6, and success! – KidBilly Sep 03 '14 at 18:48

score 8 · Answer 5 · answered Oct 07 '14 at 15:06

8

Download MySQL Connector .NET (6.9.4 on this date) from here and install it CUSTOM!
Remove the ASP.NET WEB providers option or the installer will write in machine.config!
Download MySQL for Visual Studio from here and install it CUSTOM. Be sure to check the integration options. You need this step because after Connector .NET 6.7 the installer will no longer integrate the connector with Visual Studio. This installer can take longer then expected. This is it.

You can install it from alternate download here which should have integrated with VS correctly but it did not and I got a strange error and after the reinstall it is ok.

answered Oct 07 '14 at 15:06

Ognyan Dimitrov

5,392
1
40
64

Confirming this to work for Visual Studio 2015 aswell! – konrad_pe Feb 03 '16 at 10:12
You're my hero! – Luke Dupin Apr 21 '17 at 18:43
1

Work for Visual Studio 2019 – Boomerang Jul 29 '20 at 08:58

score 7 · Accepted Answer · answered Nov 23 '10 at 14:49

Visual Studio requires that DDEX Providers (Data Designer Extensibility) be registered by adding certain entries in the Windows Registry during installation (HKLM\SOFTWARE\Microsoft\VisualStudio\{version}\DataProviders) . See DDEX Provider Registration in MSDN for more details.

score 4 · Answer 7 · answered Jun 19 '19 at 23:36

4

Installing the following packages:

Connector/NET 8.0.16: https://dev.mysql.com/downloads/connector/net/
MySQL for Visual Studio 1.2.8: https://dev.mysql.com/downloads/windows/visualstudio/

adds MySQL Database to the data sources list (Visual Studio 2017)

answered Jun 19 '19 at 23:36

j.xavier.atero

334
1
6
17

I was missing the second installer for VS2019: "MySQL for Visual Studio". – wodzu Sep 01 '19 at 14:31

score 2 · Answer 8 · answered Dec 11 '15 at 08:32

2

View ImageI have got the same problem for my vs 2013 on 64-bit machine. So i tried to download MySql extension for VS and install it on my machine. and restart the vs.

answered Dec 11 '15 at 08:32

Onjon Shahadat

31
2

score 1 · Answer 9 · answered Nov 14 '16 at 08:55

1

In order to get the MySQL Database item in the Choose Data Source window, one should install the MySQL for Visual Studio package available here (the last version today is 1.2.6):

https://dev.mysql.com/downloads/windows/visualstudio/

answered Nov 14 '16 at 08:55

Jordan

477
6
15

hi friend i installed 1.2.7 which is compatible with visual studio 2017 – Akhil May 30 '18 at 09:28
Clicking the arrow up would be the best praise. – Jordan Jun 08 '18 at 08:59

score 1 · Answer 10 · answered Dec 20 '16 at 19:09

Right Click the Project in Solution Explorer and click Manage NuGet Packages

Search for MySql.Data package, when you find it click on Install

Here is the sample controller which connects to MySql database using the mysql package. We mainly make use of MySqlConnection connection object.

 public class HomeController : Controller
{
    public ActionResult Index()
    {
        List<employeemodel> employees = new List<employeemodel>();
        string constr = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
        using (MySqlConnection con = new MySqlConnection(constr))
        {
            string query = "SELECT EmployeeId, Name, Country FROM Employees";
            using (MySqlCommand cmd = new MySqlCommand(query))
            {
                cmd.Connection = con;
               con.Open();
                using (MySqlDataReader sdr = cmd.ExecuteReader())
                {
                    while (sdr.Read())
                    {
                        employees.Add(new EmployeeModel
                        {
                            EmployeeId = Convert.ToInt32(sdr["EmployeeId"]),
                            Name = sdr["Name"].ToString(),
                            Country = sdr["Country"].ToString()
                        });
                    }
                }
                con.Close();
            }
        }

        return View(employees);
    }
}

score 0 · Answer 11 · answered Nov 20 '10 at 22:42

0

unfortunately this is not supported in the builtin tools in visual studio. however, you can create your own data provider using mysql connector but still have to integrate it from code

answered Nov 20 '10 at 22:42

Ali Tarhini

5,078
6
38
63

Any examples on how to use my own data provider to create ASP.NET Reports? All the examples I have seen use the built in wizards/tools. – JohnB Nov 22 '10 at 16:54

How to connect to a MySQL Data Source in Visual Studio

11 Answers11

Linked

Related