概述

dotConnect for MySQL（以前稱為My..NET）是一個增強型的支持ORM的MySQL數據提供程序，它基于ADO.NET技術構建以提供用于開發基于MySQL的數據庫應用程序的完整解決方案。它介紹了設計應用程序體系結構的新方法，提高了生產率，并利用了數據庫應用程序。

快速高級ADO.NET提供程序

dotConnect for MySQL提供了到MySQL數據庫的高性能連接以及許多創新的開發工具和技術。它支持各種MySQL特定的特性，例如安全的SSL和SSH連接、嵌入式服務器、壓縮協議、HTTP隧道等等。

RAD方法

dotConnect for MySQL提供了大量GUI工具，提高了您的工作效率。它集成到Visual Studio Server Explorer和其他工具中，并提供高級可視化組件編輯器來簡化組件調整。DataSet工具，例如DataSet Wizard、DataSet Editor、DataSet Manager，為您提供了創建和編輯有類型和無類型數據集的簡單方法。

ORM解決方案

dotConnect for MySQL提供了增強的ORM支持，并為ORM模型提供了捆綁的可視化設計器——實體開發器。dotConnect for MySQL支持ADO.NET實體框架、NHibernate和LinqConnect（以前稱為LINQ to MySQL）——我們自己的ORM解決方案，與Microsoft LINQ to SQL緊密兼容，同時用自己的特性擴展其功能。

特征

直接模式

允許您的應用程序直接通過TCP/IP使用MySQL，而不涉及MySQL客戶端庫。

企業圖書館

可以與Microsoft企業庫數據訪問應用程序塊一起使用。

監測

允許使用免費的dbMonitor應用程序對數據庫事件進行每組件跟蹤。

ASP.NET

實現角色、會話狀態、成員、配置文件、站點地圖和其他ASP 2.0提供程序。

BIS

使Integration Services能夠向MySQL服務器導出和導入數據。

兼容性

在.NET和.NET Compact Framework 2.0及更高版本、.NET Core和Mono上支持MySQL服務器3.23及更高版本。

dotConnect for MySQL is data provider to direct access to MySQL database server for the Microsoft .NET Framework and .NET Compact Framework. It is 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 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 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.
• MySqlDataTable - Provides all of the functionality needed to retrieve and manipulate data from a MySQL server data source.
• MySqlScript - Serves to execute series of SQL statements separated by special symbols.
• MySqlLoader - Serves to load external data into the MySQL database.
• MySqlDump - Serves to store a database or its parts as a script and also to restore database from the received script.
• MySqlMonitor - Allows to monitor dynamic SQL execution in applications that use MySQLDirect .NET.