MySQL Connector/NET 8.0.13 has been released
Posted by: Surabhi Bhat
Date: October 22, 2018 11:24AM
Date: October 22, 2018 11:24AM
Dear MySQL users, MySQL Connector/NET 8.0.13 is the first version to support Entity Framework Core 2.1 and the third general availability release of MySQL Connector/NET to add support for the new X DevAPI,which 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 http://dev.mysql.com/doc/x-devapi-userguide/en/index.html. For more information about how the X DevAPI is implemented in Connector/NET, see http://dev.mysql.com/doc/dev/connector-net. NuGet packages provide functionality at a project level. To get the full set of features available in Connector/NET such as availability in the GAC, integration with Visual Studio's Entity Framework Designer and integration with MySQL for Visual Studio, installation through the MySQL Installer or the stand-alone MSI is required. For general documentation about how to get started using MySQL as a document store, see http://dev.mysql.com/doc/refman/8.0/en/document-store.html. To download MySQL Connector/NET 8.0.13, see http://dev.mysql.com/downloads/connector/net/ Installation instructions can be found at https://dev.mysql.com/doc/connector-net/en/connector-net-installation.html Changes in MySQL Connector/NET 8.0.13 (2018-10-22, General Availability) * Important Changes * Functionality Added or Changed * Bugs Fixed Important Changes * The default value for the SslMode connection option now differs based on the protocol used to make the connection. The Preferred mode has been reintroduced in this release (see Options for Both Classic MySQL Protocol and X Protocol http://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html#connector-net-8-0-connection-options-classic-xprotocol . To summarize the default Sslmode values in the Connector/NET 8.0 (and 7.0) release series: Connector/NET 8.0.13: Preferred mode is the default for classic MySQL protocol connections only. Required mode is the default for X Protocol connections only (Preferred mode is not available for use with X Protocol). Connector/NET 8.0.8 to 8.0.12: Preferred mode is not supported for any connections. Required mode is the default for both classic MySQL protocol and X Protocol connections. Connector/NET 7.0.0 to 7.0.7: Preferred mode is the default for both classic MySQL protocol and X Protocol connections. (Bug #28687769) Functionality Added or Changed * Document Store: An incremental improvement was made to the performance of session creation with a connection string. (Bug #28343655) * Support for EF Core 2.1 was added to Connector/NET 8.0.13 and support for EF Core 2.0 was discontinued in the same connector version. Other versions of Connector/NET continue to support EF Core 2.0 (see Entity Framework Core Support http://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core.html . * The ConnectionTimeout connection option and property were reimplemented as the Connect-Timeout option (and the ConnectTimeout property) for X Protocol operations. Some aspects of the timeout behavior were changed (see Options for X Protocol Only http://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html#connector-net-8-0-connection-options-xprotocol . The new ConnectTimeout property was added to the MySqlX.XDevAPI.MySqlXConnectionStringBuilder class and the existing ConnectionTimeout property was removed. No modifications were made to the existing implementation of the ConnectionTimeout option (or property) for classic MySQL operations. * Connector/NET now provides connection pooling for applications using the X Protocol. The implementation includes the new static MySQLX.GetClient method that takes two parameters: connectionData (connection string or URI) and connectionOptions (JSON-formatted string or anonymous object containing the pooling options). Method overloading enables the following type combinations: MySQLX.GetClient(Object, Object) MySQLX.GetClient(Object, String) MySQLX.GetClient(String, Object) MySQLX.GetClient(String, String) GetClient returns the new Client object, which retrieves an existing and currently unused network connection from the pool, resets it, and uses it. Closing a session marks the underlying connection as unused and returns it to the pool. Connection options are configured as follows: // Connection options of type String Client client = MySQLX.GetClient(ConnectionData, "{ \"pooling\": { \"maxSize\": 5, \"queueTimeout\": 5000 } }"); // Connection options of type Object (anonymous object) Client client = MySQLX.GetClient(ConnectionData, new { pooling = new {maxSize = 5, queueTimeout = 5000 } }); The new keyword must be used twice when the connection options are configured using an anonymous object. Connection options are: enabled, maxSize, maxIdleTime, and queueTimeout. For more information, see Connection and Session Concepts http://dev.mysql.com/doc/x-devapi-userguide/en/devapi-connection-concepts.html . Bugs Fixed * Document Store: Connector-side validation performed when the Collection.CreateIndex method was called duplicated some of the checks already made by the server. The connector now only validates that the indexDefinition value passed to the method is a valid JSON document with the correct structure. (Bug #28343828) * EF Core: An invalid syntax error was generated when a new property (defined as numeric, has a default value, and is not a primary key) was added to an entity that already contained a primary-key column with the AUTO_INCREMENT attribute. This fix validates that the entity property (column) is a primary key first before adding the attribute. (Bug #28293927) * Document Store: A mixed alphanumeric value such as "1address" when used with the Set and Unset methods caused the operations to throw an exception. This fix resolves the way mixed values are converted into tokens to generate only one token as an identifier. (Bug #28094094) * EF Core: The implementation of some methods required to scaffold an existing database were incomplete. (Bug #27898343, Bug #90368) * Attempts to create a new foreign key from within an application resulted in an exception when the key was generated by a server in the MySQL 8.0 release series. (Bug #27715069) * A variable of type POINT when used properly within an application targeting MySQL 8.0 generated an SQL syntax error. (Bug #27715007) * The case-sensitive lookup of field ordinals was initialized using case-insensitive comparison logic. This fix removes the original case-sensitive lookup. (Bug #27285641, Bug #88950) * The MySql.Data.Types.MySqlGeometry constructor called with an array of bytes representing an empty geometry collection generated an ArgumentOutOfRangeException exception, rather than creating the type as expected. Thanks to Peet Whittaker for the patch. (Bug #26421346, Bug #86974) * Slow connections made to MySQL were improved by reducing the frequency and scope of operating system details required by the server to establish and maintain a connection. (Bug #22580399, Bug #80030) On Behalf of MySQL Release Engineering team, Surabhi Bhat
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.