Chapter 4 MySQL Connector/NET Developer Guide

Table of Contents

4.1 Introduction to MySQL Connector/NET

4.2 Connector/NET Versions

4.3 Connector/NET Installation

4.3.1 Installing Connector/NET on Windows

4.3.2 Installing Connector/NET on Unix with Mono

4.3.3 Installing Connector/NET from Source

4.4 Connector/NET Connections

4.4.1 Creating a Connector/NET Connection String

4.4.2 Managing a Connection Pool in Connector/NET

4.4.3 Handling Connection Errors

4.4.4 Connector/NET Authentication

4.4.5 Connector/NET Connection Options Reference

4.5 Connector/NET Programming

4.5.1 Using GetSchema on a Connection

4.5.2 Using MySqlCommand

4.5.3 Using Connector/NET with Table Caching

4.5.4 Preparing Statements in Connector/NET

4.5.5 Creating and Calling Stored Procedures

4.5.6 Handling BLOB Data With Connector/NET

4.5.7 Working with Partial Trust / Medium Trust

4.5.8 Writing a Custom Authentication Plugin

4.5.9 Using the Connector/NET Interceptor Classes

4.5.10 Handling Date and Time Information in Connector/NET

4.5.11 Using the MySqlBulkLoader Class

4.5.12 Connector/NET Tracing

4.5.13 Using Connector/NET with Crystal Reports

4.5.14 Asynchronous Methods

4.5.15 Binary and Nonbinary Issues

4.5.16 Character Set Considerations for Connector/NET

4.6 Connector/NET Tutorials

4.6.1 Tutorial: An Introduction to Connector/NET Programming

4.6.2 ASP.NET Provider Model and Tutorials

4.6.3 Tutorial: Using an Entity Framework Entity as a Windows Forms Data Source

4.6.4 Tutorial: Data Binding in ASP.NET Using LINQ on Entities

4.6.5 Tutorial: Generating MySQL DDL from an Entity Framework Model

4.6.6 Tutorial: Basic CRUD Operations with Connector/NET

4.6.7 Tutorial: Configuring SSL with Connector/NET

4.6.8 Tutorial: Using MySqlScript

4.7 Connector/NET for Entity Framework

4.7.1 Entity Framework 6 Support

4.7.2 Entity Framework Core Support

4.8 Connector/NET API Reference

4.8.1 MySql.Data.Common.DnsClient

4.8.2 MySql.Data.MySqlClient Namespace

4.8.3 MySql.Data.MySqlClient.Authentication Namespace

4.8.4 MySql.Data.MySqlClient.Interceptors Namespace

4.8.5 MySql.Data.MySqlClient.Replication Namespace

4.8.6 MySql.Data.Types Namespace

4.8.7 MySql.Data.EntityFramework Namespace

4.8.8 Microsoft.EntityFrameworkCore Namespace

4.8.9 MySql.EntityFrameworkCore Namespace

4.8.10 MySql.Web Namespace

4.9 Connector/NET Support

4.9.1 Connector/NET Community Support

4.9.2 How to Report Connector/NET Problems or Bugs

MySQL Connector/NET is the connector that enables .NET applications to communicate with MySQL servers.

For notes detailing the changes in each release of Connector/NET, see MySQL Connector/NET Release Notes.

For legal information, see the Legal Notices.

For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.

Licensing information.  This product may include third-party software, used under license. If you are using a Commercial release of MySQL Connector/NET, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release. If you are using a Community release of MySQL Connector/NET, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release.