dotConnect for MySQL Features

Table of Contents

  1. General usability
  2. Network and connectivity
  3. Compatibility
  4. MySQL technology support
  5. Performance
  6. ADO.NET technology support
  7. ADO.NET Entity Framework
  8. LinqConnect (formerly known as LINQ to MySQL)
  9. Workflow Foundation Support
  10. Extended data access technologies and functionality
  11. Business Intelligence Solutions Support
  12. WinForms-specific features
  13. ASP.NET-specific features
  14. Script execution
  15. SQL execution monitoring
  16. Design-time enhancements
  17. dbForge Fusion for MySQL main features
  18. Product clarity
  19. Licensing and support

General usability

  • Direct access to server data. Does not require a MySQL client library
  • Real RAD for database applications
  • Fully compliant with ADO.NET
  • 100% managed code
  • Highly usable design time support
  • Easy to deploy

Network and connectivity

  • In Direct mode does not require a MySQL client library and works directly through TCP/IP
  • Both connected and disconnected data access models
  • SSL connection to MySQL server
  • SSH client forwarding protocol
  • Connection through proxy servers
  • Connection through HTTP tunnels
  • Support for compression protocol
  • Unicode connections
  • Failover support
  • Load Balancing support

Compatibility

  • Full support of the latest versions of MySQL, including Embedded Server, Percona, and MariaDB
  • Full support for x64 architecture
  • .NET Compact Framework support
  • Mono Framework support
  • Microsoft Visual Studio 2008, 2010, 2012, 2013, and 2015 support
  • CodeGear Delphi 2007 support
  • Embarcadero Delphi Prism support
  • SQL Server 2008 Business Intelligence Solutions support
  • Sync Framework support

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 query
  • Ability to store data in the MySqlDataReader object in the FetchAll mode
  • Session identifer retrieval for session management

Performance

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

ADO.NET technology support

  • Full support for ADO.NET Entity Framework v1 - v6
  • Entity Framework Core support [New]
  • Server enumeration
  • Batch update support
  • Extended metadata information retrieval
  • Advanced CommandBuilder component with automatic refresh SQL
  • Enhanced pooling control through 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 last auto-incremented value
  • Retrieval of output parameters from stored procedures and functions

ADO.NET Entity Framework

  • Conceptual approach to enterprise development
  • High performance
  • Wide support for LINQ to Entities
  • Entity Framework Code First support
  • Entity Framework Code First Migrations support
  • Wide support for EntitySQL
  • Full CRUD (Create, Retrieve, Update, Delete) support
  • Wide support for server data types
  • Entity Framework Spatials support
  • Change tracking support
  • Object data caching
  • Inheritance mapping support (TPH, TPT, and TPCT models)
  • Ability to use stored procedures when manipulating data
  • Stored procedure import support
  • Ability to build database-independent applications
  • Full-text search support
  • Visual Studio EDM Wizard support
  • Reverse engineering of database objects to entity model
  • Support for most Entity Framework Canonical Functions
  • Visual model creation and code generation with Entity Developer
    • Update Model From Database functionality for Entity Developer
    • Update To Database with Mapping Synchronization functionality for Entity Developer
  • Illustrated tutorial to get started with Entity Framework in 5 minutes

LinqConnect (formerly known as LINQ to MySQL)

  • Easy to use
  • High performance
  • Interchangeable with Microsoft LINQ to SQL
  • Plain CLR classes used (no need to use a common base class)
  • Full CRUD (Create, Retrieve, Update, Delete) support
  • Ability to execute DML statements in batches on SubmitChanges
  • Fluent Mapping support
  • Complex type support
  • PLINQ support (connection manager redesigned for thread safety)
  • Support for different configurable algorithms for primary key generation
  • Inheritance mapping support (Table Per Hierarchy and Table Per Type)
  • Support of Visual Studio Debugger Visualizer for the DataQuery objects
  • ASP.NET Dynamic Data support with ASP.NET Dynamic Data project templates
  • Automatic configurable compiled query caching
  • Change tracking support
  • Object data caching
  • Data binding support
  • Wide support for LINQ capabilities
  • Wide support for server data types
  • Load on demand (lazy load)
  • Database transactions support
  • Server-independent interface
  • Visual model creation and code generation with Entity Developer
    • Update Model From Database functionality for Entity Developer
    • Update To Database with Mapping Synchronization functionality for Entity Developer
  • Illustrated tutorial to get started with LinqConnect in 5 minutes

Workflow Foundation Support


Extended data access technologies and functionality

  • Powerful MySqlDataTable component for manipulating individual tables or query result
  • NonBlocking mode allows fetching data asynchronously in the background
  • On-demand data fetch for data-bound controls
  • Paginal access to query result
  • Server side master-detail relation based on queries
  • Ability to refresh individual records in 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 resultset

Business Intelligence Solutions Support

  • SSIS DataFlow Source and Destination components
  • Analysis Services support
  • Reporting Services support

WinForms-specific features

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

ASP.NET-specific features


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 IDE toolwindows

Design-time enhancements


dbForge Fusion for MySQL main features

  • Integration with dotConnect for MySQL for enhanced component designers and drag and drop features
  • Stored routines and SQL script debugger
  • SQL code completion and navigation
  • Visual query builder
  • Database Explorer
  • Visual object editors
  • Database search engine
  • Code template library
  • Security Manager
  • Session Manager
  • Export/Import Wizards

Product clarity

  • Complete documentation sets integrated into Visual Studio and CodeGear Delphi
  • Integration with Visual Studio and MSDN help collections
  • Documentation available as a standalone chm file
  • A large amount of helpful demos in C#, VB, C++, and Delphi

Licensing and support

  • Included annual dotConnect for MySQL Subscription with Priority Support
  • Licensed royalty-free per developer, per team, or per site