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

user_16962495 0
Viewed 116

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

visual-studio-2019 mysql c#
2 Answers

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.

user_169624950

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.

user_179917580
Related