动态构建连接字符串
本文关键字:字符串 连接 构建 动态 | 更新日期: 2023-09-27 18:01:21
有这些项目:
ConnDatabase
ConnServer
ConnUsername
ConnPassword
作为字符串,什么是最好的方式来生成SQL服务器连接字符串,可以在web上找到。配置文件?
PS:这实际上(很可能)是为dapper
假设你正在构建一个SQL连接字符串,然后有一个专门的框架类:SqlConnectionStringBuilder
以下是MSDN文章的一个片段:
System.Data.SqlClient.SqlConnectionStringBuilder builder = new System.Data.SqlClient.SqlConnectionStringBuilder();
builder["Data Source"] = "(local)";
builder["integrated Security"] = true;
builder["Initial Catalog"] = "AdventureWorks;NewValue=Bad";
Console.WriteLine(builder.ConnectionString);
导致这个安全的(引号)值:
Source=(local);Initial Catalog="AdventureWorks;NewValue=Bad";Integrated Security=True
这个类还有助于解析连接字符串,这可能非常有用(如果不比构建连接字符串更有用,依我看):
var builder = new SqlConnectionStringBuilder();
builder.ConnectionString = myConnectionString;
var dataSource = builder["Data Source"];