如何在控制台应用中设置实体框架的连接字符串
本文关键字:框架 实体 连接 字符串 设置 控制台 应用 | 更新日期: 2023-09-27 18:36:04
我有一个包含 2 个项目的解决方案:asp 应用程序和控制台应用程序。在我的 asp 项目的 web.config 中,我有这个:
<connectionStrings>
<add name="con" connectionString="Data Source=PC-Flo'SQLExpress2008;Initial Catalog=test;Persist Security Info=True;User ID=lol;Password=lolation" providerName="System.Data.SqlClient" />
</connectionStrings>
我的连接有效。
现在我想连接我的控制台应用程序,所以在我的 App.config 中我放了同样的东西,但我有这个例外:
"System.Data.Entity.Internal.AppConfig"的类型初始值设定项 引发异常
感谢您的帮助。
应用程序配置文件:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<connectionStrings>
<add name="con" connectionString="Data Source=PC-Flo'SQLExpress2008;Initial Catalog=test;Persist Security Info=True;User ID=lol;Password=lolation" providerName="System.Data.SqlClient" />
</connectionStrings>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=" requirePermission="false" />
</configSections>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="mssqllocaldb" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
</providers>
</entityFramework>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Mvc" publicKeyToken="" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="WebGrease" publicKeyToken="" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-1.5.2.14234" newVersion="1.5.2.14234" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" publicKeyToken="" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
我删除了所有文件并将其放入其中
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="con" connectionString="Data Source=PC-Flo'SQLExpress2008;Initial Catalog=test;Persist Security Info=True;User ID=lol;Password=lolation" providerName="System.Data.SqlClient" />
</connectionStrings>
</configuration>
最后它起作用了。感谢您的帮助。