本章节介绍使用MySQL的.NET connector访问云原生数据仓库AnalyticDB MySQL版2.0集群。
using System;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;
namespace adbdemo
{
public class Tutorial2
{
public static void Main()
{
string connStr = "server=...;UID=...;database=...;port=...;password=...;SslMode=none;";
MySqlConnection conn = new MySqlConnection(connStr);
try
{
Console.WriteLine("Connecting to MySQL...");
conn.Open();
string sql = "select c_custkey, c_name from customer limit 1";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Console.WriteLine(rdr[0] + " --- " + rdr[]);
}
rdr.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
conn.Close();
Console.WriteLine("Done.");
}
}
}
文档内容是否对您有帮助?