General usability
- Direct access to server data. Does not require 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 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
Compatibility
- Full support of the latest versions of MySQL, including Embedded Server
- Full support for x64 architecture
- .NET Compact Framework support
- Mono Framework support
- Visual Studio .NET 2002, 2003, 2005, and 2008 support
- Borland Delphi 8, 2005, 2006, Turbos support
- SQL Server 2005 Business Intelligence Solutions 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 loading data
- Support for multiple query execution
- Fill DataSet with multiple query
- Ability to store data in MySqlDataReader object in 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
- 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
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
WinForms-specific features
- Flexible data binding with DataLink component
- InterForm technology for cross-form components cooperation
- Global position synchronization within a data source
ASP.NET-specific features
- ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider
- MySqlDataSource web component
- MySqlCacheDependency component to control Cache item dependencies in ASP.NET applications
- Data provider and set of data access modules for DotNetNuke
Script execution
- Advanced script execution features with 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 DBMonitor utility for advanced tracing analysis and control
- Per-component SQL tracing
- Optional log output to IDE toolwindows
Design-time enhancements
- Automatic component registration in toolbox
- Advanced integration with Visual Studio 2005/2008, 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 MyDirect .NET 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 in design time
dbForge Fusion for MySQL main features
- Integration with MyDirect .NET 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 .NET and Borland Delphi
- Integration with Visual Studio and MSDN help collections
- A large amount of helpful demos in C#, VB, C++, and Delphi
Licensing and support
- Included annual MyDirect .NET Subscription with Priority Support
- Licensed royalty-free per developer, per team, or per site
© 2002-2008 Devart. All rights reserved.