MySqlConnector for ADO.NET

MySqlConnector is the recommended ADO.NET connector for MariaDB Server. MySqlConnector is a community-maintained open-source project that provides the best performance, reliability, and compatibility with MariaDB products.

MySqlConnector is an ADO.NET data provider with support for MariaDB Server. It is licensed under the MIT License.

• Installation via NuGet

• Documentation

• Version History

• GitHub

• On Travis

MariaDB Contributions

Recent Major Contributions

• Support zero-configuration SSL with MariaDB: #1500

  • For MariaDB Server 11.4+

  • Available from version 2.4.0

• Rewrite server redirection logic based on latest MariaDB specification: #1499

  • For MariaDB Server 11.3+

  • Available from version 2.4.0

• Performance: Avoid SET NAMES commands when not necessary: #1497

  • For MariaDB Server 11.5+

  • Available from version 2.4.0

• Ensure correct foreign key query using join with table name: #1600, #1601

Performance Optimizations

• Implement faster parsing for result sets with multiple rows: #1330

• Support per-query variables for CommandBehavior.SchemaOnly and SingleRow: #1312

• Support skipping metadata for prepared statements with MariaDB 10.6 and later: #1301

• Available from version 2.3.0

• Small parameter encoding improvements: #1293, #1294, #1295, #1296

Timeout and Command Improvements

• Query timeout using per query variables: #1304

• Command timeout implementation improvement: #1336

• Various timeout improvements: #1337

Authentication and Protocol Support

• Support MariaDB GSSAPI authentication: #577

  • Available from version 0.47.0

• Permit multi-authentication: #1303

• Add a client parameter to specify SSL version(s): #450

Version Compatibility

• Support new MariaDB version numbers: #1259

  • For MariaDB Server 11.0+

  • Available from version 2.2.6

• MariaDB version parsing evolution: #1311

• Permit real prepared stored procedure: #1314