Advantages of dotConnect for MySQL
Wide Coverage of MySQL Features
By providing access to the most advanced database functionality, dotConnect for MySQL allows developers to harness the full capabilities of the MySQL server and optimize their database applications. dotConnect for MySQL stands out as the set of components with the widest support of MySQL functionality.
dotConnect for MySQL has widest possible connectivity options. It can operate in Direct mode without MySQL client library and in Client mode with usage of libmysql.dll. dotConnect for MySQL utilizes Secure Sockets Layer (SSL) protocol, Secure Shell (SSH) protocol, as well as connections through proxy servers and HTTP tunnels. dotConnect for MySQL supports all MySQL server versions since 3.23, including MySQL Embedded Server.
The goal of dotConnect for MySQL is to enable developers to write efficient and flexible database applications. The dotConnect for MySQL assemblies are implemented using optimized code and advanced data access algorithms. Components undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers.
Comprehensive Support for ADO.NET Technology Features
dotConnect for MySQL supports new ADO.NET features and technologies as soon as they are released. This includes base-class-based provider model, provider factories, connection string builder, metadata schemas, asynchronous commands, pooling enhancements, batch update support, provider-specific types, server enumeration, database change notification support and so on. dotConnect for MySQL will continue supporting the newest standards and innovations of the .NET Framework.
Database Application Development Extensions
dotConnect for MySQL has rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers for typed MySQL-specific components, toolset for live data binding and much more. dotConnect for MySQL integrates tightly with Visual Studio 2005/2008/2010, Delphi, and SQL Server 2005 Business Intelligence Solutions. Last, but not least, there is dbForge Fusion for MySQL to design your database schema and manipulate table data - all within your favorite IDE.
dotConnect for MySQL has extra components designed to simplify some tasks and support MySQL-specific technologies. Particularly, MySqlScript serves to execute series of SQL statements, MySqlLoader serves to load external data into MySQL databases, and MySqlDump serves to backup or restore a whole database or its parts.
ADO.NET Entity Framework Support
ADO.NET Entity Framework is a conceptual approach to database application development with focus on objects instead of relational data. The flexible architecture of Entity Framework is made up of well-thought layers and modules. Entity Framework optimizes the development process with object-relational mapping, SQL-based entity query language, and LINQ. See our Entity Framework tutorial and Entity Framework Query Samples article for a quick start with the technology.
dotConnect for MySQL fully supports the Entity Framework capabilities, which allows you to base your object-oriented applications on MySQL. dotConnect for MySQL includes a set of demos to use as a starting point. All standard Entity Framework samples can be easily ported to dotConnect for MySQL.
dotConnect for MySQL includes support for LinqConnect technology. The technology allows you to employ object-oriented database application development with less efforts and in less time. Compared to ADO.NET Entity Framework, LinqConnect is better suited for RAD-style development, is easier to start with, and somewhat richer with server-oriented features like server-specific types. See our LinqConnect tutorial for a quick start with the technology.
Both Connected and Disconnected Models
dotConnect for MySQL combines connected and disconnected data access models in single MySqlDataTable component, which allows you to design more flexible application architecture and use full power of data binding.
dotConnect for MySQL is the winner of Readers Choice Merit Awards of Visual Studio Magazine in 2006 and 2007. dotConnect for MySQL is acknowledged as one of the top Visual Studio .NET products honored.
The following list describes the main features of dotConnect for MySQL.
- Direct access to MySQL server
- 100% managed code
- High performance
- Easy to deploy
- Supports the latest versions of MySQL server including MySQL Embedded server
- All MySQL data types support
- .NET Compact Framework support
- Entity Framework support
- LinqConnect support
- ASP.NET Provider Model support
- Operates in both connected and disconnected models
- Powerful MySqlDataTable component as all-in-one table data access solution
- Auxiliary components for SQL scripts and bulk data transfer
- Extra data binding capabilities
- Cross-form components cooperation
- Ability of monitoring query execution
- Licensed royalty-free per developer, per team, or per site
See All Features
dbForge Fusion for MySQL within dotConnect for MySQL
dotConnect for MySQL Developer Edition includes Standard Edition of dbForge Fusion for MySQL.
dbForge Fusion for MySQL is a powerful tool designed to automate and simplify MySQL database development process. It integrates into Microsoft Visual Studio .NET and Borland Delphi making all database development and administration tasks available from your favorite IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements, query and manipulate data in different ways.
Main advantages of dbForge Fusion for MySQL are:
- Convenient server browsing
- Simplified database objects creating and altering
- Advanced SQL handling
- Powerful data editing
- Wide MySQL support
- Direct access to MySQL server
- Extra design-time capabilities
- Help integrated into IDE
dbForge Fusion for MySQL is also available as standalone application. For more information on the product please refer to dbForge Fusion for MySQL pages.