对SqlConnection使用context connection = true

Question

对SqlConnection使用context connection = true

c# dapper

题

我有这个简化的课程：

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;
        }
}

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

新的SqlConnection（“context connection = true”）

我可以调整配置文件中的连接字符串，还是操纵IDbConnection的“连接”实例来实现这一目的？

cs0815

热门答案

您可以使用SqlConnectionStringBuilder来更改已从配置文件中检索的连接字符串。这意味着你可以保持原始连接字符串只读。

SqlConnectionStringBuilder sqlb = new SlConnectionStringBuilder(_connectionString); 
sqlb.ContextConnection = true;
string modifiedConnString = sqlb.ToString();

pijemcolu

在 Stack Overflow 上查看更多

Steve · Accepted Answer · 7/4/2016 1:19:44 PM

我建议使用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只是一个偏好问题。

对SqlConnection使用context connection = true

题

Fastest Dapper Plus Extensions

一般承认的答案

热门答案

Performance

Expression Evaluator