0

Hi I am trying to connect mysql DB using Entity framework but when i am adding the ado.net entity model vs13 does not show the driver for mysql .enter image description here

Below are the steps that i have performed to solve the issue but it does not work for me, 1) Installed nuget packages for EF ,mysql.data &mysql.data.entity

2) Copy and paste the mysql connector dll's(mysql.data,mysql.data.entity.ef,mysql.web) in private assemblies of vs12 folder available in installed location. To check whether i am using right credential, I used odbc data source available in my machine and its showing the driver and allowing me a connection but same is not working for VS13

3) I have also installed the EF tool which is suggested in one of the stackover flow question and on msdn website i have installed latest version of EF tool Is anything missing from my end?

Pavan
  • 337
  • 5
  • 23
  • Does entity first or database first approaches to EF work for MySQL? (Have you tried code first which doesn't depend on any VS integration?) – Richard Nov 14 '17 at 12:00
  • database first more precisely "EF designer from database" – Pavan Nov 14 '17 at 12:01
  • This is not duplicate question as i have installed the higher version of suggested tool. – Pavan Nov 14 '17 at 12:14
  • Look at the answer to the linked question: there is a separate install for VS integration. – Richard Nov 14 '17 at 13:03
  • yes i installed the latest tool for vs integration.The issue was with connector. After going in details i found that latest connectors of MySQL are developed for .net core.So this does not work for existing framework of 4.5. To solve this issue i have downloaded the "MySql.Data.dll" of release 6.8.8 (nearly 3 release old) and it started working after updating the reference.Happy coding..... – Pavan Nov 14 '17 at 17:36

0 Answers0