Dela via

Azure Database for MySQL libraries for .NET

  • Artikel

Overview

Work with data and resources stored in Azure Database for MySQL.

Client APIs

The recommended client library for accessing Azure Database for MySQL is MySQL's Connector/Net. Use the package to connect to the database and execute SQL statements directly.

Install the NuGet package directly from the Visual Studio Package Manager console or with the .NET Core CLI.

Visual Studio Package Manager

Install-Package MySql.Data

.NET Core CLI

dotnet add package MySql.Data

Code Example

Connect to a MySQL database and execute a query:

/* Include this "using" directive...
using MySql.Data.MySqlClient;
*/

string connectionString = "Server=[servername].mysql.database.azure.com; " +
    "Database=myDataBase; Uid=[userid]@[servername]; Pwd=myPassword;";

// Best practice is to scope the MySqlConnection to a "using" block
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
    // Connect to the database
    conn.Open();

    // Read rows
    MySqlCommand selectCommand = new MySqlCommand("SELECT * FROM MyTable", conn);
    MySqlDataReader results = selectCommand.ExecuteReader();
    
    // Enumerate over the rows
    while(results.Read())
    {
        Console.WriteLine("Column 0: {0} Column 1: {1}", results[0], results[1]);
    }
}

Samples