CData ADO.NET Provider for MySQL 2018 - Online Help
Questions / Feedback?

CData ADO.NET Provider for MySQL 2018

CData ADO.NET Provider for MySQL 2018 - Build 18.0.6883

Overview

The CData ADO.NET Provider for MySQL 2018 offers the most natural way to access MySQL data from .NET applications. The provider wraps the complexity of accessing MySQL data in an easy-to-integrate, fully managed ADO.NET Data Provider.

The CData ADO.NET Provider for MySQL 2018 hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

  • DataBind to MySQL using Visual Studio wizards.
  • Real-time access to MySQL.
  • Comprehensive support for CRUD (create, read, update, and delete) operations.

Getting Started

See Getting Started for A-Z guides on authenticating and connecting to MySQL data. See the CData KB for quickstarts to using the provider with many popular applications.

Using ADO.NET

See Using ADO.NET for guides to using ADO.NET features including:

  • Standard ADO.NET classes: The provider has the same ADO.NET architecture as the native .NET data providers for SQL Server and OLEDB. Code with familiar classes such as MySQLConnection, MySQLCommand, MySQLDataAdapter, MySQLDataReader, MySQLDataSource, MySQLParameter, etc.
  • SSRS deployment: The provider supports automatic deployment for SSRS 2005 and above. See Using ADO.NET (SSRS).

Schema Discovery

See Schema Discovery to use standard ADO.NET schema collections to discover schema information and other metadata.

LINQ and Entity Framework

See Using ADO.NET (Entity Framework) to create EF 5 or EF 6 data models, LINQ to Datasets, etc.

Connection String Options

The Connection properties describe the various options that can be used to establish a connection.

 
 
Copyright (c) 2018 CData Software, Inc. - All rights reserved.
Build 18.0.6883.0