Key Features of dotConnect for MySQL

Compatibility

  • Support for MySQL server versions 8.4, 8.0, 5.7, 5.6, 5.5, 5.4, 5.1, 5.0, 4.1, 4.0 and 3.23 including Embedded servers (starting with 4.1), 64-bit MySQL servers, Percona, and MariaDB (version 11, 10, 5)
  • Support for Amazon RDS for MySQL, Amazon RDS for MariaDB, and Amazon RDS for Aurora
  • x64 and x86 architecture
  • Windows, Linux, macOS

Platforms

  • .NET 5.0-9.0
  • .NET Core 1.x-3.0
  • .NET Standard 1.3-2.1
  • .NET Frameworks 2.0–4.8
  • ASP.NET Core
  • Blazor
  • .NET MAUI (previously Xamarin)
  • .NET Compact Framework
  • Mono Framework
  • Sync Framework

.NET languages

  • C#
  • VB.NET
  • F#

ORM support

  • Entity Framework Core 1.x-9.0
  • Entity Framework v1-v6
  • Dapper 1.x, 2.x
  • NHibernate 1.x-5.x
  • LINQ to Entities

Entity Framework features

  • Spatials support
  • Change tracking and object data caching support
  • Inheritance mapping support (TPH, TPT, TPCT models)
  • Stored procedures and functions support
  • Ability to build database-independent applications
  • Full-text search support

With Entity Developer

  • Visual model creation and code generation
  • Model update from the database
  • Database update with mapping synchronization
  • Reverse engineering of database objects to an entity model
  • Storage schema editing of Entity Framework
  • Standalone usage or Visual Studio integration

Security standards

  • SSL/TLS, SSH connections
  • Connection through proxy servers and HTTP tunnels
  • Connected and disconnected data access models
  • Support for the compression protocol
  • Unicode connections
  • Failover support
  • Load balancing support
  • Encryption algorithms: RC4, RC4-56, RC4-128, RC4-256, DES-40, DES-56, DES-112, DES-168, AES-128, AES-192, AES-256
  • Checksum algorithms: MD5, SHA1, SHA256, SHA384, SHA512
  • Operation in the FIPS 140-2 mode in Windows
  • Passing credentials via MySqlCredential class, based on SecureString

Certification

  • DigiCert Trusted G4 Code Signing RSA4096 SHA384
    2021 CA1

Performance

  • Intelligent fetch block size control
  • Advanced connection pooling
  • High-performance batch processing
  • Support for the prepared statements in the protocol for maximum performance

IDE integration

Visual Studio

Microsoft Visual Studio 2008-2022

  • DataSet Wizard to create and edit typed MySQL-oriented datasets
  • DataSet Manager to list and bind datasets in the project
  • DataSet Editor to edit dataset contents
  • Advanced design-time component and property editors
  • IntelliSense descriptions for dotConnect for MySQL classes
  • Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
  • Syntax highlighting and SQL code completion in design-time editors
  • TableMappings editor
  • Convenient instant data preview and management at design time

Without design-time integration

  • Visual Studio Code
  • JetBrains ReSharper and Rider
  • CodeGear Delphi 2007
  • Embarcadero Delphi Prism
  • Support for the Enterprise Library Data Access Application Block (DAAB)

ADO.NET architecture

  • Batch update support
  • Extended metadata information retrieval
  • Advanced CommandBuilder component with automatic refresh SQL
  • Enhanced pooling control through the connection string
  • Connection string builder
  • Provider factory for generating key data access classes
  • Asynchronous command execution
  • Provider-specific types support
  • Password change API
  • Database Change Notification Support
  • Possibility to retrieve the last auto-incremented value
  • Retrieval of output parameters from stored procedures and functions

NuGet availability

Devart.Data.MySql 
dotnet add package Devart.Data.MySql
Devart.Data.MySql.EFCore 
dotnet add package Devart.Data.MySql.EFCore
Devart.Data.MySql.EFCore.Design 
dotnet add package Devart.Data.MySql.EFCore.Design
Devart.Data.MySql.EF6 
dotnet add package Devart.Data.MySql.EF6

Script execution

  • Advanced script execution features with the MySqlScript component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading

SQL execution monitoring

  • Extended SQL tracing capabilities with MySqlMonitor component
  • Support for the dbMonitor utility for advanced tracing analysis and control
  • Per-component SQL tracing
  • Optional log output to the IDE

MySQL technology support

  • All MySQL data types support
  • Stored procedures support
  • Returning result sets from stored procedures
  • View editing
  • MySqlDump component to store a database or its parts as a script and then restore it
  • MySqlLoader component for fast data loading
  • Support for multiple query execution
  • Fill DataSet with multiple queries
  • Ability to store data in the MySqlDataReader object in the FetchAll mode
  • Session identifer retrieval for session management

WinForms-specific features

  • Flexible data binding with the DataLink component
  • InterForm technology for cross-form components cooperation
  • Global position synchronization within a data source

Extended DataTable and DataSet functionality

  • Powerful MySqlDataTable component for manipulating individual tables or query results
  • NonBlocking mode allows fetching data asynchronously in the background
  • On-demand data fetch for data-bound controls
  • Paginal access to query results
  • Server side master-detail relation based on queries
  • Ability to refresh individual records in the MySqlDataTable component
  • Support for Enterprise Library Data Access Application Block (DAAB)
  • Object-oriented building of SELECT statements
  • Extended warning and error information retrieval
  • Extended interface for processing execution exceptions
  • MySqlDataAdapter.Fill method with sequential fetch support
  • Ability to defer fetching of some columns in a result set