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.
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 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.
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.