dotConnect for MySQL - .NET - V5.0 - 概要

概要 | 価格及びライセンス | 試用版とそのダウンロード | 互換性 | 開発元詳細 | 結果

結果

dotConnect for MySQL by Devart (formerly Core Lab)

Data provider for direct access to MySQL. dotConnect for MySQL is a full-featured 100% managed .NET data provider for direct access to MySQL for .NET Framework and .NET Compact Framework. The provider can access MySQL server using native MySQL network protocol directly or through MySQL client. dotConnect for MySQL provides functionality for connecting to MySQL database, executing commands, and retrieving results. Supports the latest versions of MySQL, all MySQL data types and Embedded server. Offers SSL connection to MySQL server and SSH client forwarding protocol support and provides stored procedures support for MySQL 5.0 and returning result sets from stored procedures.

Editions: dotConnect for MySQL has three editions: Professional, Standard and Mobile. Standard edition includes ADO.NET core classes and classes for native data types only. Professional edition includes additional classes, design-time extensions and wizards. Mobile is for the .NET Compact Framework

dotConnect for MySQL is data provider to direct access to MySQL database server for the Microsoft .NET Framework and .NET Compact Framework. It completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. dotConnect for MySQL data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider. The Data provider can access MySQL server either using native MySQL network protocol directly or through MySQL client library. It allows to create lightweight and fast applications working with MySQL.

dotConnect for MySQL 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.

dotConnect for MySQL 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.

Following the main features of the dotConnect for MySQL Data Provider

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

MySqlScript component to execute scripts

MySqlLoader component for fast loading data

Ability to store data in DataReader object

Paginal access to query result

Named parameters support

Ability of monitoring query execution by DBMonitor

Advanced design-time editors

Integrated MySQL Developer Tools 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

dotConnect for MySQL supports MySQL server version 5.0, 4.1, 4.0 and 3.23. The provider works with .NET Framework 1.0, 1.1, 2.0 and .NET Compact Framework, and can be used with the following development environments:

Microsoft Visual Studio .NET 2008

Microsoft Visual Studio .NET 2005

Microsoft Visual Studio .NET 2003, 2002

Microsoft ASP.NET Web Matrix

Borland Delphi 2005, 2006, Delphi 8

Borland C#Builder

What's new in dotConnect for MySQL V5.0?

MyDirect .NET renamed to dotConnect for MySQL

Supported LINQ to MySQL

Added Entity Developer for LINQ to MySQL

What's new in dotConnect for MySQL V4.8x? - This version adds support for dbForge Fusion for MySQL 3.00 (formerly known as MyDeveloper Tools) and improves support for ADO.NET Entity Framework.

What's new in dotConnect for MySQL V4.7x?

Added DB server-based data paging for web applications

MySqlDataSource design time improvements

ASP.NET demo pack added

DotNetNuke 4.7 support added

Added support for CLIENT_INTERACTIVE connection option

MySqlSelectStatement.TryParse method added

DataLink.DataSource property can refer to another DataLink com

What’s new in V4.x?

Application development enhancement

Added DataSet Manager to control dataset instances in the project

Added DataSet Editor for convenient datasets manipulation

New MySqlDataSet class to use with MySqlDataTable

New component DataLink added for flexible data binding

New capabilities added to MySqlDataTable class

Added capability for cross-form components cooperation

Design time visualization extended

Supported addin, DataSet Wizard, and MySQL Developer Tools integration with Borland Developer Studio

.NET 2 features

Added MySqlDependency class to support Database Change Notification

Added MySqlDataSourceEnumerator class to support Server Enumeration feature

Added support for Batch Update in MySqlDataAdapter

Added support for returning provider-specific types in MySqlDataReader and MySqlDataAdapter

SQL Server 2005 Business Intelligence Solutions supported

Added data provider and set of data access modules for DotNetNuke

Added MySqlSelectStatement class for building SELECT statements

Added MySqlDecimal class to represent MySQL DECIMAL type

Added MySqlBinaryString class to represent BINARY and VARBINARY type

Added list of hosts in connection form and connection properties

Added MySqlLoader.LoadTable() method

Base level classes moved to the new assembly CoreLab.Data.dll

New demo projects added

Added DbLoader class that serves to load external data into database

Added MySQLDirect .NET information to Visual Studio 2005 splash screen and About box

dotConnect for MySQL 3.55.18 new feature:

Windows Vista support added

dotConnect for MySQL V3.50.10 new features:

Implemented advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource

Mono support added

ASP.NET 2.0 providers added: Membership Provider, Role provider, Session State Provider, Profile provider

Dataset Wizard added

Enterprise Library Data Access Application Block support added

OUT and INOUT parameters in stored procedures supported

Borland Delphi 2006 support added

Added support for stored procedures in FetchAll=true and Prepared modes

Provider invariant name changed

Added streaming support for MySqlScript

Added list of Frequently Asked Questions

MySQL Developer Tools installation separated from MySQLDirect .NET Professional installation

MySQLDirect .NET Professional is now compatible with version 1.70 of MySQL Developer Tools

Capability to call MySQLDirect .NET runtime assemblies by partially trusted code added

Licensing enhanced for applications that use DbProviderFactory

Migration wizard design enhanced

PartNumbers: PC-516026-176365 516026-176365 PC-516026-176370 516026-176370 PC-516026-176368 516026-176368 PC-516026-176366 516026-176366 PC-516026-176371 516026-176371 PC-516026-176369 516026-176369 PC-516026-176367 516026-176367 PC-516026-176372 516026-176372 PC-516026-176373 516026-176373 PC-516026-176374 516026-176374 PC-516026-176375 516026-176375 PC-516026-176376 516026-176376 PC-516026-176377 516026-176377 PC-516026-176378 516026-176378 PC-516026-176379 516026-176379

PurchaseOptions: dotConnect for MySQL Data Provider V5.0 - Standard 1 Developer License - with 1 Year Subscription , dotConnect for MySQL Data Provider V5.0 - Standard 1 Developer License - Upgrade from Standard V3.x , dotConnect for MySQL Data Provider V5.0 - Standard 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for MySQL Data Provider V5.0 - Professional 1 Developer License - with 1 Year Subscription , dotConnect for MySQL Data Provider V5.0 - Professional 1 Developer License - Upgrade from Professional V3.x , dotConnect for MySQL Data Provider V5.0 - Professional 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for MySQL Data Provider V5.0 - Mobile 1 Developer License - with 1 Year Subscription , dotConnect for MySQL Data Provider V5.0 - Mobile 1 Developer License - Upgrade from Mobile V3.x , dotConnect for MySQL Data Provider V5.0 - Mobile 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) - with 1 Year Subscription , dotConnect for MySQL Data Provider Standard Subscription Renewal 1 Developer License Subscription Renewal , dotConnect for MySQL Data Provider Standard Subscription Renewal 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , dotConnect for MySQL Data Provider Professional Subscription Renewals 1 Developer License Subscription Renewal , dotConnect for MySQL Data Provider Professional Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal , dotConnect for MySQL Data Provider Mobile Subscription Renewals 1 Developer License Subscription Renewal , dotConnect for MySQL Data Provider Mobile Subscription Renewals 1 Site Wide License (Allows Unlimited Developers at a Single Physical Address) Subscription Renewal

Resources: Read the dotConnect for MySQL License Agreement, Download the dotConnect for MySQL V5.0 evaluation on to your computer - Limited Functionality

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Component

Component Type: .NET Class, .NET Compact Framework, 100% Managed Code

Built Using: Visual C# .NET

Compatible Containers: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Internet Information Server 5.0, Microsoft Internet Information Server 4.0, Delphi 2006 (10.0), Delphi 2005 (9.0), Delphi 8.0, C#Builder, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0, ASP.NET Web Matrix, MySQL 5.0

Product Class: Business Components

Search Items: New Product May 05, New Product Aug 05

Keywords: crlab corelab SQL query language Database DB Management Database DB Connectivity Author corelab