MySQL for Visual Studio Release Notes

2.5 Changes in MySQL for Visual Studio 2.0.2 (2016-04-11, Development Milestone)

MySQL for Visual Studio 2.0.2 M1 is the first development release of MySQL for Visual Studio to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see X DevAPI User Guide. For more information about how the X DevAPI is implemented in MySQL for Visual Studio, and its usage, see Code Editors.

Known limitation of this release: SSL connections are not yet supported.

Functionality Added or Changed

  • Updated the MySQL parser's grammar to include keywords introduced in MySQL 5.7.

  • Because the deprecated "File", "New", "Project", "Create a New Project", "Templates", "MySQL Files" option no longer exists, the resulting error is no longer present. In other words, the deprecated "MySQL Project Templates" were removed, in favor of "MySQL Item Templates".

  • Support for the "IF [NOT] EXISTS" clause for CREATE, DROP, and ALTER USER statements was added.

  • The JavaScript and Python editors now auto-detect the port for the X Protocol, and uses it to execute JavaScript and Python scripts. Before, it was hardcoded to 33060.

Bugs Fixed

  • The New MySQL Script - Python option would not function with MySQL Server 5.7.9 and higher. The error was similar to "An error occurred when trying to launch a MySql Script window".

  • Minor optimizations to the script editor window.

  • Added support for Visual Studio 2015 with .NET Framework 4.6.

  • The "New MySql Script" command bar button did not function. The error was similar to "An error occurred when trying to launch a MySql Script window".

  • The triple double quote """ used for multiline comments did not function correctly in the Python editor.

  • The JavaScript editor now only shows when working with connections using MySQL 5.7 and higher.

  • Opening an editor window for .mysql files that connected to MySQL Server versions lower than 5.6.6 would not function.

  • The Tree View in the Results tab did not display data headers.