Data Source=192.168.1.100,1433;Initial Catalog=MyDB;User ID=sa;Password=StrongPwd;
或使用 Server 別名:
Server=192.168.1.100,1433;Database=MyDB;User ID=sa;Password=StrongPwd;
Server=MyServer;Database=MyDB;Integrated Security=SSPI;
Integrated Security 可取值:True、SSPI(推薦)、False。設置為 True/SSPI 時 User ID/Password 會被忽略。
Server=MyServer\SQL2019;Database=MyDB;Integrated Security=SSPI;
Server=MyServer;Database=MyDB;Integrated Security=SSPI;
Min Pool Size=5;Max Pool Size=100;Connect Timeout=30;Pooling=true;
Server=MyServer;Database=MyDB;User ID=sa;Password=Pwd;
Encrypt=True;TrustServerCertificate=True;
Server=MyServer;Database=MyDB;Integrated Security=SSPI;Application Name=OrderService_WebAPI;
var builder = new SqlConnectionStringBuilder
{
DataSource = @"(local)\SQLEXPRESS",
InitialCatalog = "Northwind",
IntegratedSecurity = true, // SSPI
MinPoolSize = 5,
MaxPoolSize = 100,
ConnectTimeout = 30,
ApplicationName = "MyApp_Console"
};
using (var conn = new SqlConnection(builder.ConnectionString))
{
conn.Open();
// ...
}
優點:智能提示、屬性驗證、自動處理特殊字符轉義、避免拼接錯誤。
ConnectionString 類型設置。Properties.Settings.Default.MyConnStr。using System;
using System.Data;
using System.Data.SqlClient;
namespace ConnectDB
{
class Program
{
static void Main()
{
var cs = "Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=SSPI";
using (var conn = new SqlConnection(cs))
using (var cmd = new SqlCommand("SELECT TOP 10 * FROM Customers", conn))
using (var adapter = new SqlDataAdapter(cmd))
{
var ds = new DataSet();
adapter.Fill(ds);
Console.WriteLine(ds.GetXml());
}
Console.ReadKey();
}
}
}
| 關鍵字 | 別名 | 說明 |
|---|---|---|
| Data Source | Server, Address, Addr | 服務器地址[實例][,端口] |
| Initial Catalog | Database | 初始數據庫 |
| Integrated Security | Trusted_Connection | True/SSPI=Windows認證,False=SQL認證 |
| User ID | UID | SQL 登錄用戶 |
| Password | PWD | 密碼 |
| Encrypt | - | True 強制 TLS 加密 |
| TrustServerCertificate | - | True 跳過證書驗證(開發/自簽環境) |
| Connect Timeout | Connection Timeout | 連接超時秒數,默認 15 |
| Pooling | - | 啟用連接池(默認 true) |
| Min/Max Pool Size | - | 池大小範圍 |
| Application Name | App | 顯示在 sys.dm_exec_sessions.program_name |