我試圖在同一個控制臺應用程序上從 MySQL 和 SQL Server 檢索數據。我設法從 MySQL 檢索數據，但是當我嘗試從 SQL Server 檢索數據時，出現System.ArgumentException: 'Option not supported. Parameter name: multipleactiveresultsets'錯誤。以下是我的app.config：<?xml version="1.0" encoding="utf-8" ?><configuration> <configSections> <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" /> </configSections> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" /> </startup> <connectionStrings> <add name="MySQLDb" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;port=3306;database=sakila;uid=some_user;password=some_password"/> <add name="SQLDb" providerName="System.Data.SqlClient" connectionString="data source=USER-PC\SQLEXPRESS;initial catalog=MyDatabase;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"/> </connectionStrings> <entityFramework codeConfigurationType="MySql.Data.Entity.MySqlEFConfiguration, MySql.Data.Entity.EF6"> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/> <providers> <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6"/> <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/> </providers> </entityFramework></configuration>還有我的 C#：#region MySQL.{ var dbContext = new MySQLDb(); var dbSet = dbContext.Set<Actor>(); var actors = dbSet.ToList();}#endregion#region SQLServer.{ var dbContext = new SQLDb(); var dbSet = dbContext.Set<User>(); var users = dbSet.ToList(); // <-- Throw exception.}#endregion如果我在 C# 代碼中禁用entityFrameworksection inapp.config和 MySQL 代碼塊，我可以毫無問題地從 SQL Server 檢索數據。版本信息
2 回答
瀟湘沐
TA貢獻1816條經驗 獲得超6個贊
問題是我們正在使用MySql.Data.Entity.MySqlEFConfiguration（在 中app.config）將默認連接工廠設置為使用MySqlConnectionFactory。
解決方案是使用自定義DbConfiguration代替MySql.Data.Entity.MySqlEFConfiguration來阻止設置默認連接工廠。
public class MySQLDbConfiguration : DbConfiguration
{
public MySQLDbConfiguration()
{
SetProviderServices(MySqlProviderInvariantName.ProviderName, new MySqlProviderServices());
SetProviderFactory(MySqlProviderInvariantName.ProviderName, new MySqlClientFactory());
}
}
在代碼中的某處將實例聲明為只讀，
private static readonly MySQLDbConfiguration DBConfig = new MySQLDbConfiguration();
并在使用任何 EF 功能之前設置配置
DbConfiguration.SetConfiguration(DBConfig);
而我們的app.config現在變成
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
</startup>
<connectionStrings>
<add name="MySQLDb" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;port=3306;database=sakila;uid=some_user;password=some_password"/>
<add name="SQLDb" providerName="System.Data.SqlClient" connectionString="data source=USER-PC\SQLEXPRESS;initial catalog=MyDatabase;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"/>
</connectionStrings>
</configuration>
如果您選擇使用app.config而不是派生自定義DbConfiguration，則可以執行以下操作
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<!-- Alternative to custom DbConfiguration. -->
<configSections>
<section name = "entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<entityFramework>
<providers>
<provider invariantName = "MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6"/>
</providers>
</entityFramework>
<system.data>
<DbProviderFactories>
<remove invariant = "MySql.Data.MySqlClient" />
<add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.10.8.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/>
</DbProviderFactories>
</system.data>
<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
</startup>
<connectionStrings>
<add name="MySQLDb" providerName="MySql.Data.MySqlClient" connectionString="server=localhost;port=3306;database=sakila;uid=some_user;password=some_password"/>
<add name="SQLDb" providerName="System.Data.SqlClient" connectionString="data source=USER-PC\SQLEXPRESS;initial catalog=MyDatabase;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"/>
</connectionStrings>
</configuration>
- 2 回答
- 0 關注
- 628 瀏覽
添加回答
舉報
0/150
提交
取消