CODEWITHSUNDEEP
c#mysqlentity-frameworkdataprovider
yair facio
yair facio

Reputation: 23

How to connect to a MySQL Data Source in Visual Studio 2019?

I'm trying to create a new connection using MySql as a Data Provider in Visual Studio 2019, but the list of Data source doesn't show me MySql. So I check out my mysql-connector and I had the 8.0.15.msi version. I found out that i should have the older version because starting with version 6.7, Connector/Net will no longer include the MySQL for Visual Studio integration. So i uninstalled my current version and reinstalled this one 6.6.6 but it still dosen't work.

What connector should i Install for visual studio 2019?

enter image description here

Upvotes: 2

Views: 8108

Answers (1)

Márcio Rigues
Márcio Rigues

Reputation: 66

I had same problem and I solved with this.

First update your components to:

  • Connector/NET 8.0.17
  • MySQL for Visual Studio 2.0.5
  • MySQL Server 5.5 or higher
  • Entity Framework 6 assemblies
  • .NET Framework 4.0 or higher (.NET Framework 4.5.1 or higher is required for Connector/NET 6.10 and 8.0)

Second review the project packages reference and config files because the NuGet Package Manager don't update it correctly in this Visual Studio version.

This article is in portuguese and You can translate it at Google. It is a step-by-step about Visual Studio 2019 and MySQL integration written by myself: http://sistemaseweb.com.br/Pagina/Detalhes/90/migrando-e-atualizando-um-projeto-net-mvc-3-com-mysql-no-visual-studio

Upvotes: 5

Related Questions