4,103 questions
Using ADO.NET Entity Framework with MySql Data Provider
Barish
0
Reputation points
I'm going to start an ASP.NET Web Application project that uses the MySql database. I also need to create an ADO.NET Entity Data Model.
I know I need to install "MySql for Visual Studio Tool" and "MySql Connector/NET".
- I have installed VS2019 Community.
- I installed MySql Connector/NET 8.0.28.
- I have installed MySql for Visual Studio Tool 1.2.10.
- I open VS2019. I am successfully connecting to the remote mysql database from Server Explorer > Data Connections.
- I created a new MVC Web Application(4.5.2 / 4.6.1 / 4.7.2).
- I have installed MySql.Data.EntityFramework package.
- In the last step of the ADO.NET Entity Data Model installation wizard (Choose Your Data Connection), the installer suddenly closes.
I can share the database connection information that I will connect to via message. I also write the database properties below. I couldn't find which versions would work in harmony. Can you try this on your own machine and let me know after you make sure it works? I need your support My Microsoft Family.
MySql Database information:
- Server: localhost via TCP/IP
- Server type: MariaDB
- Server connection: SSL is not being used Documentation
- Server version: 10.6.9-MariaDB - mariadb.org binary distribution
- Protocol version: 10
- User: u1307312_user1A6@localhost
- Server charset: UTF-8 Unicode (utf8mb4)
- Microsoft-IIS/10.0
- Database client version: libmysql - mysqlnd 7.4.33
- PHP extension: mysqli Documentation curl Documentation mbstring Documentation
- PHP version: 7.4.33
The result of the query show variables like '%char%' :
- character_set_client: utf8mb4
- character_set_connection: utf8mb4
- character_set_database: utf8mb4
- character_set_filesystem: binary
- character_set_results: utf8mb4
- character_set_server: utf8mb4
- character_set_system: utf8mb3
- character_sets_dir: C:\Program Files\MariaDB 10.6\share\charsets\
I created a video recording for you. You can check out my actions here. veed.io/view/361a18d3-67f4-4420-8642-a9809d92a937?panel=share
Developer technologies | .NET | Other
Developer technologies | ASP.NET | Other
3,598 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff2023-06-26T03:23:56.04+00:00 Hi @Barish,
I have installed VS2019 Community.
In your video you are using VS2017. Which version of VS do you want to use, and which version of VS are you using((Help -->About Microsoft Visual Studio) in Visual Studio ) ?
Unfortunately I didn't reproduce your problem in Microsoft Visual Studio Community 2019 Version 16.11.27. Have you tried clicking "Test Connection" to see if the link was successful?
-
Barish 0 Reputation points
2023-08-11T15:14:56.5+00:00 I have installed VS2019 Community.
Yes, I spelled that wrong. It will actually be VS2017.
Of course, I made a test link. Connection successful; my problem is that it suddenly shuts down when the next screen is about to open.
There is something you don't understand. I can connect to MsSql database. The database I can't connect to is MySql.
-
Barish 0 Reputation points
2023-08-21T06:02:53.06+00:00 I still haven't found a solution. how can i solve this problem?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 10%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHT%3C/text%3E%3C/svg%3E)
Hervé Torche 0 Reputation points2024-02-28T13:54:15.33+00:00 Hello, Did you finally find a solution ? I've exactly the same problem...
Sign in to comment
Sign in to answer