-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Pronojit
Message 1 in Discussion
MySQLDirect .NET Data Provider - http://crlab.com/mysqlnet/
MySQLDirect .NET is data provider to direct
access to MySQL database server for the Microsoft .NET Framework. It
completely based on ActiveX Data Objects for the .NET Framework
(ADO.NET) technology. ADO.NET provides a rich set of components for
creating distributed, data-sharing applications. It is an integral
part of the .NET Framework, providing access to relational data,
XML, and application data.
MySQLDirect .NET data provider can be used in
the same way as the SQL Server .NET or the OLE DB .NET Data
Provider.
MySQLDirect .NET uses native MySQL programming
interface to access to MySQL database. It allows to create
lightweight and fast applications working with MySQL.
MySQLDirect .NET provides functionality for
connecting to MySQL database, executing commands, and retrieving results.
Those results can be processed directly, or placed in an ADO.NET DataSet
for further processing while in a disconnected state. While in the
DataSet, data can be exposed to the user, combined with other data from
multiple sources, or passed remotely between tiers. Any processing
performed on the data while in the DataSet can then be reconciled to MySQL
database.
MySQLDirect .NET data provider is designed to be
lightweight. It consists of a minimal layer between MySQL database and
your code. This extends functionality without sacrificing performance.
There are core classes that make up MySQLDirect .NET
data provider. The following table describes those classes and their
functions.
MySqlConnection -
Establishes a connection to MySQL database and can begin a transaction.
MySqlCommand - Executes a
SQL statements at MySQL database, and exposes parameters.
MySqlDataReader - Exposes
and reads a forward-only stream of data from MySQL database.
MySqlDataAdapter -
Populates a DataSet and resolves updates with MySQL database.
MySqlTransaction -
Enables you to enlist commands in transactions at MySQL database.
MySqlParameter - Defines
input, output, and return value parameters for commands.
MySqlException - Returned
when an error is encountered at MySQL database. For an error encountered
at the client, MySQLDirect .NET data provider throws a .NET Framework
exception.
Along with the core classes listed in the preceding
table, MySQLDirect .NET data provider also contains the classes extending
its base functionality and allowing to accomplish additional tasks.
MySqlCommandBuilder - A
helper object that will automatically generate command properties of
MySqlDataAdapter and populate the MySqlParameters collection of
MySqlCommand object.
MySqlMonitor - Allows to
monitor dynamic SQL execution in applications that use MySQLDirect .NET.
MySqlScript - Servers to
execute series of SQL statements separated by special symbols.
Key features
Following the main features of the MySQLDirect .NET
Data Provider.
Direct access to MySQL server
100% managed code
High performance
Easy to deploy
Supports the latest versions of MySQL
All MySQL data types support
Support MySQL Embedded server
Connection pooling feature
Support multiple query execution
Fill DataSet with multiple query
MySqlScript component to execute scripts
Ability to store data in DataReader object
Ability of monitoring query execution
Advanced design-time editors
Integrated MySQLBuilder tool for 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
Requirements
Prior to running Setup to install the MySQLDirect
.NET, you must already have the .NET Framework 1.0 or 1.1 installed on the
computer. If the .NET Framework is not installed, the Setup program for
the provider will fail.
Also the MySQLDirect .NET requires available
MySQL client library (libmysql.dll).
Compatibility
MySQLDirect .NET is tested with MySQL server version
4.1, 4.0 and 3.23. The provider works both with .NET Framework 1.0 and 1.1
versions, and can be used with Visual Studio .NET 2003, Visual Studio .NET
2002 and Borland C#Builder 1.0.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
