'How to open design window on VS 2019 for mysql database table?

I'm creating a windows form app with visual studio 2019. I have connected to MySQL. When I right click on tables and click create table this error pops up

Cannot create a design window for the selected object. Creation failed with message: The requested .NET Framework Date Provider was not found. Please confirm that Connector/NET is installed.

I have Connector/NET version 8.0.29 installed on MySQL installer. And MySQL for Visual Studio installed as well. How do I create tables in visual studio?

Here is my installer - MySQL installer

VS shows a connection - Server Explorer

c++sharpmysqlvisual-studio-2019


Solution 1:[1]

So I never could get the VS table to open up, maybe it's not the ideal way. So I have just been going to MySQL workbench and updating the table there and carrying the information over.

Solution 2:[2]

the reason may be that the version of the mysql connection database plug-in is wrong. You can change the version of the downloaded connector, and the problem will be solved.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Krad
Solution 2 Housheng-MSFT

Related Questions