MySQL Forums
Forum List  »  MySQL for Visual Studio

Advanced SQL Generation Options Disabled
Posted by: Patrick Castillo
Date: October 05, 2018 09:22AM

Hi All,

Using
- Visual Studio 2017
- MySQL for VS 2.05
- MySQL Connector .net 6.9.9

Been trying to create a datasource for my AspxGridView employing the use of the Advanced SQL generation options which seem to be "Greyed" out. Since the table(which HAS a primary key) contains 50 fields, this method would obviously be more convenient than manually writing the Update statement with parameters.
*Note: I am able to have success when working with my local MySQL(v5.6.38) but the above issue occurs working with our production MySQL(v8.0.12)

My question is how do I solve to work with the newer MySQL version?
Do I require some updates?

Any help is greatly appreciated

Patrick

Options: ReplyQuote


Subject
Views
Written By
Posted
Advanced SQL Generation Options Disabled
163
October 05, 2018 09:22AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.