您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

用于 .NET 的 Azure Database for MySQL 库Azure Database for MySQL libraries for .NET

概述Overview

使用 Azure Database for MySQL 中存储的数据和资源。Work with data and resources stored in Azure Database for MySQL.

客户端 APIClient APIs

建议用于访问 Azure Database for MySQL 的客户端库是 MySQL 的 Connector/NetThe recommended client library for accessing Azure Database for MySQL is MySQL's Connector/Net. 使用包连接到数据库并直接执行 SQL 语句。Use the package to connect to the database and execute SQL statements directly.

直接从 Visual Studio 包管理器控制台或使用 .NET Core CLI 安装 NuGet 包Install the NuGet package directly from the Visual Studio Package Manager console or with the .NET Core CLI.

Visual Studio 包管理器Visual Studio Package Manager

Install-Package MySql.Data

.NET Core CLI.NET Core CLI

dotnet add package MySql.Data

代码示例Code Example

连接到 MySQL 数据库并执行查询: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