Use ADO.NET with MySQL in Visual Studio 2015

Question

I want to use ADO.NET with MySQL, so I’ve installed MySQL Connector and MySQL for Visual Studio:

(I use Visual Studio 2015 and Windows 10) When I create a new ADO.NET, I don’t have MySQL:

I don’t know how I can get MySQL to work with Entity Framework… I followed a tutorial, but it doesn’t work.

Solution 1

From this release: http://dev.mysql.com/doc/relnotes/mysql-for-visual-studio/en/visual-studio-news-1-2-4.html it is possible.

In fact, I followed, and installed MySQL connector for Visual Studio 2015 correctly: http://dev.mysql.com/downloads/windows/visualstudio/

Solution 2

At the moment it is not possible. See info posted about EF 7 - Beta 4:

What’s Next

[...]

Providers

There is work underway to enable the following database providers. We’ve also had contact with many other providers who are planning to provide EF7 support.

• SQLite (being developed by the EF team)
• PostgreSql (being developed by the npgsql team)
• MySql (being developed by the MySql team)

Solution 3

This combination finally worked for me:
MySQL for Visual Studio - v1.2.6
MySQL Connector/Net - v6.9.8
(Visual Studio 2015 Community and Windows 10)

Solution Reference: MySQL Forumn - "Can't Create Datasource on VS2015"

Solution 4

You should use NuGet package for MySQL For Entity Framework

In Visual Studio 2015:

• Tools
• Nuget Package Manager
• Manage NuGet Packages for Solution

Search for MySQL and install the desired one.
Rebuild and its ready

Solution 5

I've been stuck with this issue many days I tried to install MySQL tool for Visual Studio from here

Everything is working now, Goodluck

View more solutions