SqlConnectionStringBuilder

最新推荐文章于 2025-09-12 11:03:10 发布

原创最新推荐文章于 2025-09-12 11:03:10 发布 · 671 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#sql server #database #system #server #服务器

ADO.NET 专栏收录该内容

19 篇文章

订阅专栏

本文介绍如何使用 C# 和 SqlConnectionStringBuilder 类来构建针对不同 SQL Server 版本的有效连接字符串。包括设置数据源、数据库名称、安全验证方式及类型系统版本等关键参数。

using System;
using System.Data.SqlClient;

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = Environment.MachineName;     // builder["server"]
builder.InitialCatalog = "ProductSet";           // builder["database"]
builder.IntegratedSecurity = true;              // builder["trusted_connection"]
builder.TypeSystemVersion = "SQL Server 2000"; // builder["Type System Version"]

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = string.Format(@"{0}/SQLEXPRESS", Environment.MachineName);
builder.InitialCatalog = "ProductSet";
builder.IntegratedSecurity = true;
builder.TypeSystemVersion = "SQL Server 2005";

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.DataSource = string.Format(@"{0}/SQLEXPRESS", Environment.MachineName); // Environment.MachineName <=> "." 本地服务器名。
builder.AttachDBFilename = @"|DataDirectory|/ProductSet.mdf"; // "|DataDirectory|" <=> "." 当前工作目录。
builder.IntegratedSecurity = true;
builder.UserInstance = true;
builder.TypeSystemVersion = "SQL Server 2008";

SqlConnection sql = new SqlConnection(builder.ConnectionString);