时间戳

首页 > 解决方案 > 连接字符串没有从 dbconnection 传递到 dbfactory？

c# - 连接字符串没有从 dbconnection 传递到 dbfactory？

问题描述

我目前正在使用dbfactory? for accessing my database, but for some reason is the connection string empty when it is being initialized from adbconnection ？

怎么来的？

代码：

        var connect = System.Configuration.ConfigurationManager.ConnectionStrings["Db"];
        DbConnection db = new SqlConnection(connect.ConnectionString);
        Console.WriteLine("DbConnection: " + db.ConnectionString);
        DbProviderFactory factory = DbProviderFactories.GetFactory(db);
        System.Data.Common.DbConnection cn = factory.CreateConnection();
        Console.WriteLine("DbConnection from factory: " + cn.ConnectionString);
        Repository = new Repository();
        return Repository.Load(() => cn);

输出：

DbConnection: Server=<connetionstring>
DbConnection from factory:

标签： c#sqldatabasefactory

解决方案

试试下面的代码：

//get the information out of the configuration file.
var connectionStringSettings = 
       ConfigurationManager.ConnectionStrings["Db"];

//get the proper factory and mandatory to have SQL Provide name in the connection string
DbProviderFactory factory = 
  DbProviderFactories.GetFactory(connectionStringSettings.ProviderName);

//create a command of the proper type.
DbConnection conn = factory.CreateConnection();
//set the connection string
conn.ConnectionString = connectionStringSettings.ConnectionString;

//open the connection
conn.Open();

Repository = new Repository();
return Repository.Load(() => conn);

推荐阅读