IBM DB2 Core:ASP.NET Core 2.1和Microsoft企业库的连接字符串

Question

我正在将此Microsoft.EnterpriseLibrary端口用于.Net Core。它需要一个配置文件app.config，其中指定了连接字符串。我尝试在另一个工作项目中使用相同的连接字符串，但在这里不起作用。

如何为ASP.NET Core 2.1指定DB2连接字符串？

这就是我尝试过的：

<connectionStrings>
<add name="Development" connectionString="server=MY.SERVER.COM:446;database=DBXX;user id=USERXX;password=PASSWORDXX;" providerName="IBM.Data.DB2.Core"/>
</connectionStrings>

但是当我执行这个：

DatabaseFactory.SetDatabaseProviderFactory(
new DatabaseProviderFactory(
new SystemConfigurationSource(false).GetSection
), 
false
);
var db = DatabaseFactory.CreateDatabase("Development");

它给了我一个例外：

Exception has occurred: CLR/System.InvalidOperationException
An exception of type 'System.InvalidOperationException' occurred in Microsoft.Practices.EnterpriseLibrary.Data.dll but was not handled in user code: 'The connection string for the database 'Development' does not exist or does not have a valid provider.'
Inner exceptions found, see $exception in variables window for more details.
Innermost exception     System.Configuration.ConfigurationErrorsException : The requested database Development does not have a valid ADO.NET provider name set in the connection string.

我认为提供商名称不正确，但我在网上找不到任何可用的示例。

Answer 1

好的，我解决了它。结果我找不到IBM.Data.DB2.Core的任何提供程序，所以我配置了我的app.config文件，如下所示：

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="system.data" type="System.Data.Common.DbProviderFactoriesConfigurationHandler, Microsoft.Practices.EnterpriseLibrary.Data, Version=6.0.0.0, Culture=neutral, PublicKeyToken=null" requirePermission="true" />
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=6.0.0.0, Culture=neutral, PublicKeyToken=null" requirePermission="true" />
</configSections>
<dataConfiguration defaultDatabase="Development" />
<connectionStrings>
<add name="Development" connectionString="server=MY.SERVER.COM:446;database=DBXX;user id=USERXX;password=PASSWORDXX;" providerName="IBM.Data.DB2.Core"/>
</connectionStrings>
<system.data>
<DbProviderFactories>
<remove invariant="IBM.Data.DB2.Core" />
<add name="DB2 Data Provider" invariant="IBM.Data.DB2.Core" description=".Net Framework Data Provider for DB2" type="IBM.Data.DB2.Core.DB2Factory, IBM.Data.DB2.Core" />
</DbProviderFactories>
</system.data>
</configuration>

在研究IBM程序集时，我发现有一个名为DB2Factory的DbProviderFactory实现类。如果app.config文件配置有如上所示的system.data部分，则该类可以用作提供程序名称。