Pros/Cons verses the free MyODBC from MySQl
Posted: Wed 24 Nov 2004 16:34
So what are the props/cons of using MySQLDirect verses the free MyODBC from MySQL
- 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