c# - 对 SqlConnection 使用 context connection=true

Question

我有这个简化的类:

public abstract class BaseDaService
{
    private readonly string _connectionString;

    protected BaseDaService(string connectionString)
    {
        _connectionString = connectionString;
        }

        protected IDbConnection OpenConnection()
    {
        IDbConnection connection = new SqlConnection(_connectionString);
        connection.Open();
        return connection;
        }
}

此处的连接字符串来自配置文件。我想在执行以下操作时使用我的配置文件中的凭据:

new SqlConnection("context connection=true")

我能否调整配置文件中的连接字符串或操纵 IDbConnection 的“连接”实例来实现此目的？

Answer 1

我建议使用 SqlConnectionStringBuilder类

 // With a default parameter set to false you can still use
 // the same code as before and change only the spots where
 // the context is required
 protected IDbConnection OpenConnection(bool useContext = false)
 {

    string newConString = _connectionString;
    if(useContext)
    {
        SqlConnectionStringBuilder scs = new SqlConnectionStringBuilder(_connectionString);
        scs.ContextConnection = true;
        newConString = scs.ToString();
    }
    IDbConnection connection = new SqlConnection(newConString);
    connection.Open();
    return connection
}

当然，更改 app.config 只是一个偏好问题。