Pros/Cons verses the free MyODBC from MySQl
Pros/Cons verses the free MyODBC from MySQl
So what are the props/cons of using MySQLDirect verses the free MyODBC from MySQL
Re: Pros/Cons verses the free MyODBC from MySQl
MySQLDirect .NET offers the following features most of them aren't provided by MyODBC.
- Direct access to MySQL server
- Doesn't require MySQL client library and uses MySQL protocol directly
- 100% managed code
- High performance
- Easy to deploy
- Supports the latest versions of MySQL server
- All MySQL data types support
- Compact Framework support
- Stored procedures support
- Support MySQL Embedded server
- Connection pooling feature
- Support multiple query execution
- Fill DataSet with multiple query
- Ability to store data in MySqlDataReader object
- Paginal access to query result
- MySqlScript component to execute scripts
- MySqlLoader component for fast loading data
- Named parameters support
- Ability of monitoring query execution
- Advanced design-time editors
- Integrated DbTools for browsing database schema, manipulate database objects and visual building queries
- Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
- Help integrated into Visual Studio .NET
- Free support for registered users
- Licensed per a developer without royalty fee