MySQL for Visual Studio Release Notes
MySQL for Visual Studio now prompts for action when it detects any conflicts in its configuration files that were introduced after MySQL for Visual Studio was installed. Errors associated with this type of configuration conflict prevent the creation of data sources and table adapters.
A new Configuration Update Tool can resolve the conflicts between Connector/NET and MySQL for Visual Studio libraries as they are detected (see MySQL for Visual Studio Configuration Update Tool). To complete the action, it is necessary to restart affected versions of Visual Studio manually after the tool finishes updating the files. (Bug #29884031, Bug #82617)
MySQL for Visual Studio now supports all editions of Microsoft Visual Studio 2019. In addition, this release removes support for Visual Studio versions 2012 and 2013. (Bug #29616463, Bug #94937)
The MySQL Website Configuration tool was renamed and extended to
also automate entry updates to the
app.config
file (in addition to the
web.config
file). The newly renamed MySQL
Application Configuration tool preserves the functionality used
to simplify website development and now extends the
configuration capabilities of the tool to manage dependencies
required when running the Entity Data Model Wizard.
(Bug #29490017)
Connections to MySQL using SSL PEM encryption or standard TCP/IP over SSH now are supported by MySQL for Visual Studio (see Making a Connection).
Several installation errors caused the wrong version or edition of Visual Studio to be identified, which then resulted in the deployment of MySQL for Visual Studio files to the wrong folder or to a file structure that represented multiple versions Visual Studio that were neither selected nor installed on the host computer. (Bug #30225436, Bug #96576)
A secondary window opened unexpectedly when a user with
insufficient database privileges (GRANT
SELECT
and GRAN SHOW VIEW
)
attempted to alter the definition of an existing view. This fix
introduces an error message to explain the condition in detail.
(Bug #30001906)
From code, it was possible to create an instance of
SqlDataSource
, make a connection to a MySQL
server, and then populate an ASP.NET control. However,
attempting the same sequence using the Visual Studio Configure
Data Source designer produced a object-reference error when the
data source was being configured in the designer (and MySQL Connector/NET
6.10.8 was installed) and also at runtime of the web
application.
As part of a related fix, the data source now populates ASP.NET
controls from custom queries as expected at runtime. Likewise,
the designer now permits configuration when the 6.10.8 version
of MySQL Connector/NET is installed with one caution. When using the
Specify columns from a table or view
option, the Configure Data Source designer generates the query
using bracket characters ( []
) as delimiters
for identifiers, which produces an invalid MySQL statement. The
brackets can be removed manually after the data source is
created. Alternatively, the second option in the designer
associated with generating queries from the data source,
Specify a custom SQL statement or stored
procedure, is the preferred option to use.
(Bug #28148998, Bug #91136)
The TableAdapter Configuration Wizard in Visual Studio configured with a valid MySQL connection produced an error, instead of generating the expected TableAdapter. Now, the error condition is resolved when MySQL Connector/NET 6.10.8 (or higher) or MySQL Connector/NET 8.0.14 (or higher) are available for use by MySQL for Visual Studio. (Bug #27857627, Bug #90390)