Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release
of MySQL for Visual Studio 1.2.9.

This is a maintenance release for 1.2.x. It can be used for
production environments.

MySQL for Visual Studio is a product that includes all of the
Visual Studio integration functionality to create and manage
MySQL databases when developing .NET applications.

MySQL for Visual Studio is installed using the MySQL Installer
for Windows which comes in 2 versions:
   * Full (415.1 MB) which includes a complete set of MySQL products
     with their binaries included in the downloaded bundle.
   * Web (18.6 MB – a network install) which will just pull MySQL
     for Visual Studio over the web and install it when run.

You can download MySQL Installer from our official Downloads page at
http://dev.mysql.com/downloads/installer/.

MySQL for Visual Studio can also be downloaded by using the product
standalone installer found at
http://dev.mysql.com/downloads/windows/visualstudio/.

Changes in MySQL for Visual Studio 1.2.9 (2019-10-21, General
Availability)

     * Functionality Added or Changed
     * Bugs Fixed

Functionality Added or Changed

     * 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
(https://dev.mysql.com/doc/visual-studio/en/visual-studio-install.html#visual-studio-install-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
(https://dev.mysql.com/doc/visual-studio/en/visual-studio-making-a-connection.html)).

Bugs Fixed

     * 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)

On Behalf of MySQL Release Engineering Team,
Sreedhar S