0

I'm trying to set up a web API that accesses a MySQL database using Entity Framework. To do this, I have downloaded this connector. However, I am unable to figure out how to get this working. When I create the ADO .NET Entity Data Model, it asks for a source, but all options are Microsoft SQL Server. If someone could point me in the right direction, I would appreciate it.

Edited to add additional information below:

I'm trying to follow the instructions listed here. My problem is that even thoguh I have downloaded the connector, I do not see a MySQL database as a possible connection type. I'm confused as to why this could be and what steps i could take to resolve the problem.

What should appear: enter image description here

What I have on my screen: enter image description here

Improve this question
1
  • The problem is I am using an Express edition, which apparently doesn't do anything but Microsoft SQL Server by design Commented Jan 20, 2014 at 16:40

3 Answers 3

Reset to default
2

Install latest MySql Connector. Following link will help you.

http://dev.mysql.com/downloads/connector/net/

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

It's working for me:

http://dev.mysql.com/downloads/mirror.php?id=395665

Saludos!

Improve this answer

Comments

0

I installed mysql for visual studio, later mysql connector net and works fine!

mysql to vs: http://dev.mysql.com/downloads/file/?id=458484

mysql connector net http://dev.mysql.com/downloads/connector/net/

Regards,

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.