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

CodePudding user response：

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.

CodePudding user response：

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.