NET(C#)数据库连接

以下列出了用于连接各种数据库的代码片段：

SQL Server

using System.Data.SqlClient;

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder
{
  DataSource = "localhostSQLEXPRESS",
  InitialCatalog = "myDatabase",
  IntegratedSecurity = true,
};

using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
{
  // 使用连接进行操作
}

MySQL

using MySql.Data.MySqlClient;

MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder
{
  Server = "localhost",
  Database = "myDatabase",
  UserID = "myUser",
  Password = "myPassword",
};

using (MySqlConnection connection = new MySqlConnection(builder.ConnectionString))
{
  // 使用连接进行操作
}

PostgreSQL

using Npgsql;

NpgsqlConnectionStringBuilder builder = new NpgsqlConnectionStringBuilder
{
  Host = "localhost",
  Database = "myDatabase",
  Username = "myUser",
  Password = "myPassword",
};

using (NpgsqlConnection connection = new NpgsqlConnection(builder.ConnectionString))
{
  // 使用连接进行操作
}