1

I am creating a project with ASP.NET and which would be connected on our University website and their currently using XAMPP MySQL on their system so I need to adjust on their database technology at the same time I want to implement Entity Framework of C# for faster development. Thanks you.

Ive already tried adding references on the project like MySQL.Data and installing MySQL Connector for Visual Studio but turns out it is for the MySQL not the XAMPP MySQL.

Improve this question
5
  • There’s no “XAMPP MySQL”, there’s just MySQL. What problems did you have connecting to it? Commented Apr 27, 2019 at 4:26
  • @SamiKuhmonen Sir the one included when installing XAMPP thats the database I need to be able to work on Entity Framework for my project Commented Apr 27, 2019 at 4:50
  • And it’s MySQL, just like any other. It’s not “XAMPP MySQL”, it’s MySQL. So what problems did you have when using the packages you mentioned to connect to it? Commented Apr 27, 2019 at 4:51
  • When creating ADO.NET Entity Data Model the is no MySQL on the Data Source when I try to change it. Commented Apr 27, 2019 at 4:59
  • I have narrowed down the problem. On the "Entity Data Model Wizard" when I choose "EF Designer from database" then click "New Connection" if I try to change Data Source the "MySQL Data Provider" is not on the list. I have already installed Connector Net and MySQL for VS. Im not sure maybe I need a specific versions of the drivers. Im currently using Visual Studio 2017 Community Edition. Commented Apr 28, 2019 at 3:54

1 Answer 1

Reset to default
1

You can connect to your MySQL db in Visual Studio by going to the Server Explorer and click on the Connect to Database. Then select Microsoft ODBC Data Source and click continue. Make sure you enter your connection string. This might be of help to you : https://www.youtube.com/watch?v=EhqknuizUKk

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

7 Comments

Hi Thanks for this but I encountered another problem. I was able to use Microsoft ODBC Data Source (ODBC). But I cant seem to see the MySQL ODBC 5.2 Unicode Driver. Should I install something like a driver?
Use the MySQL Connector driver you installed
How do I use it? I already installed that MySQL Connector. I also installed a new driver from this dev.mysql.com/downloads/connector/odbc/5.2.html but MySQL ODBC Unicode Driver still doesnt show on the Data Source.
Have you also tried this youtube.com/watch?time_continue=122&v=K3GZidOwGmM
I was able to make it work now and able to add it on the Server Explorer but the problem is still the same there is no Data Source for MySQL when I try to create ADO.NET Entity Data Model
|

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.