Changes in MySQL Connector/NET 7.0.2 (2016-04-11, Milestone 1)

MySQL Connector/Net 7.0.2 M1 is the first development release of MySQL Connector/Net to add support for the new X DevAPI. 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 X DevAPI, see X DevAPI User Guide. For more information about how the X DevAPI is implemented in Connector/Net, see http://dev.mysql.com/doc/dev/connector-net.

Please note that X DevAPI requires MySQL Server version 5.7.12 or higher with the X Plugin enabled. For general documentation about how to get started using MySQL as a document database, see Using MySQL as a Document Store.

• Functionality Added or Changed

• Bugs Fixed

Functionality Added or Changed

• Document Store: The getLastInsertId() method was renamed to getAutoIncrementValues().

• Document Store: The getLastDocumentIds() method was added to access the last generated ID even when using add() or insert() method chaining.

• A Column Interface was added.

• Document Store: Bind support was added to NodeSession.SQL().

• Support was added to use a URI type string for connections. See Connecting to the Server Using URI-Like Strings or Key-Value Pairs.

Bugs Fixed

• An error was emitted when calling a stored procedure that returned a table.

• The FetchOne() method now returns null when there are no more rows, when before it threw an exception.

• Document Store: After the Execute() method is called and yields a successful result, parameters are now available to reuse using the same statement.

• Document Store: For NodeSession, the SetCurrentSchema("[schema]") method was added to change the schema in a session using "USE". The GetCurrentSchema() method was added to retrieve the current schema in a session using "SELECT DATABASE()", or return null if a schema is not active.

• Document Store: Setting a database attribute in a connection string now automatically creates a schema object in the session object.

• Document Store: Creating a session using the anonymous type would throw an exception.