arrow-left

All pages
gitbookPowered by GitBook
1 of 3

Loading...

Loading...

Loading...

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 NuGetarrow-up-right

  • Documentationarrow-up-right

hashtag
MariaDB Contributions

hashtag
Recent Major Contributions

  • Support with MariaDB:

    • For MariaDB Server 11.4+

    • Available from version

hashtag
Performance Optimizations

  • Implement faster parsing for result sets with multiple rows:

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

  • Support skipping metadata for prepared statements with and later:

hashtag
Timeout and Command Improvements

  • Query timeout using per query variables:

  • Command timeout implementation improvement:

  • Various timeout improvements:

hashtag
Authentication and Protocol Support

  • Support :

    • Available from version

  • Permit multi-authentication:

hashtag
Version Compatibility

  • Support new MariaDB version numbers:

    • For MariaDB Server 11.0+

    • Available from version

Rewrite server redirection logic based on latest MariaDB specification:
  • For MariaDB Server 11.3+

  • Available from version

  • Performance: Avoid SET NAMES commands when not necessary:

    • For MariaDB Server 11.5+

    • Available from version

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

  • Available from version
  • Small parameter encoding improvements: , , ,

  • Add a client parameter to specify SSL version(s):
    MariaDB version parsing evolution:
  • Permit real prepared stored procedure:

  • Version Historyarrow-up-right
    GitHubarrow-up-right
    On Travisarrow-up-right
    zero-configuration SSLarrow-up-right
    #1500arrow-up-right
    2.4.0arrow-up-right
    #1330arrow-up-right
    #1312arrow-up-right
    #1301arrow-up-right
    #1304arrow-up-right
    #1336arrow-up-right
    #1337arrow-up-right
    #577arrow-up-right
    0.47.0arrow-up-right
    #1303arrow-up-right
    #1259arrow-up-right
    2.2.6arrow-up-right
    #1499arrow-up-right
    2.4.0arrow-up-right
    #1497arrow-up-right
    2.4.0arrow-up-right
    #1600arrow-up-right
    #1601arrow-up-right
    2.3.0arrow-up-right
    #1293arrow-up-right
    #1294arrow-up-right
    #1295arrow-up-right
    #1296arrow-up-right
    #450arrow-up-right
    #1311arrow-up-right
    #1314arrow-up-right

    Other .NET Connectors

    Some other ADO.NET connectors are:

    hashtag
    MySQL Connector/NET

    MySQL Connector/NETarrow-up-right should generally work with MariaDB.

    hashtag
    dotConnect for MySQL

    is a free ADO.NET data provider that supports MariaDB.

    • It seamlessly integrates with Visual Studio 2008-2017.

    • It supports .NET Framework 2.0-4.7, and .NET Core 1.x and 2.0

    • The Commercial edition additionally provides ORM support: Entity Framework v1-v6 and Entity Framework Core, NHibernate, LinqConnect; bundled ORM visual designer tool and many other features.

    dotConnect for MySQLarrow-up-right

    .NET Connector

    Comprehensive guide to ADO.NET connectors for MariaDB. MySqlConnector is the recommended ADO.NET connector for MariaDB. This guide covers connection strings, DbConnection/DbCommand classes, parameteri

    MariaDB 10.6
    MariaDB GSSAPI authentication
    spinner
    spinner