彩票走势图

概述

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.