dotConnect for MySQL is an enhanced data provider built over ADO.NET architecture and a development framework with a number of innovative technologies. With state of the art ORM solutions such as Entity Framework and LinqConnect, it introduces new approaches for designing applications and boosts productivity of database application development. Key
Features:
*Flexible Connectivity.
dotConnect for MySQL can operate in Direct mode without MySQL client library and in Client mode with usage of libmysql.dll.
*Database Application Development Extensions.
dotConnect for MySQL has a rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers, toolset for live data binding, DDEX, and much more.
*MySQL Advanced Features.
Support dotConnect for MySQL allows developers to harness full capabilities of the MySQL server. dotConnect for MySQL supports such MySQL-specific features as secure SSL and SSH connections, embedded server, compression protocol, HTTP tunneling and more.
*ORM Support.
dotConnect for MySQL offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. It offers you advanced support for Model-First and Database-First design approaches and flexible T4 template-based code generation for the model. dotConnect for MySQL supports Entity Framework v1 - v6.4 and Entity Framework Core 5, NHibernate, and LinqConnect. dotConnect for MySQL supports such Entity Framework features as Entity Framework Spatials, Code First, Code First Migrations.
*Workflow Foundation Support.
Provides support for MySQL Workflow Instance Store and Workflow Tracking.
*BIS Support.
dotConnect for MySQL supports Reporting and Analytics services and offers Source and Destination Data Flow components for Integration Services *Support for ASP.NET Identity 1 and 2, Sync Framework
v8.4 [Aug 25, 2015]
Visual Studio 2015 is supported
The Sql Modes connection string parameter for setting MySQL server sql_mode is implemented
The possibility to use .IsRowVersion() method for properties with non-binary data types when using the fluent mapping approach is added
The Parent property is added to the IInheritanceConfiguration interface
The Use ObservableCollection property of the DbContext template is implemented (Entity Framework models)
The behaviour is changed: now the 1:1 and 1:0..1 associations are displayed differently on the diagram (LinqConnect models).