dotConnect for MySQL Features

General usability

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

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

Conceptual approach to enterprise development
High performance
Wide support for LINQ to Entities
Entity Framework Code First support [New]
Entity Framework Code First Migrations support [New]
Wide support for EntitySQL
Full CRUD (Create, Retrieve, Update, Delete) support
Wide support for server data types
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
Visual Studio EDM Wizard support
Reverse engineering of database objects to entity model
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

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

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

ASP.NET data providers: Membership, Role, Session State, Profile, Personalization, Site Map, Web Event
The MySqlDataSource web component
The MySqlCacheDependency component to control Cache item dependencies in ASP.NET applications
Data provider and set of data access modules for DotNetNuke

Automatic component registration in the toolbox
Advanced integration with Visual Studio 2008, 2010, and 2012, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component MySqlDataSource
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

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