如何将SQL Server CE与Enterprise Library 5 DatabaseFactory集成
本文关键字:Library Enterprise DatabaseFactory 集成 CE SQL Server | 更新日期: 2023-09-27 18:26:02
我得到一个
"尝试获取类型的实例时发生激活错误数据库,密钥"
每当我将默认数据库引用到SQL Server CE 时,我的DatabaseFactory.CreateDatabase()
出现异常
我试着检查问题是否只是我的.dll引用,我能够证明这是错误的,因为我仍然能够连接到真正的SQL Server 2008数据库。
这是我的配置:
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" requirePermission="false"/>
</configSections>
<dataConfiguration defaultDatabase="sqlCEDB"/>
<connectionStrings>
<add name="sqlCEDB"
connectionString="Data Source=|DataDirectory|'sqlCEDB.sdf;Password='somepassword'"
providerName="Microsoft.SqlServerCe.Client.3.5" />
</connectionStrings>
以下是我如何创建数据库实例:
private Database db;
protected internal Database DB
{
get
{
if (db == null)
db = DatabaseFactory.CreateDatabase();
return db;
}
}
解决方案
更改配置属性已解决:providerName="System.Data.SqlServerCe.3.5"
解决方案
已解决更改配置属性:providerName="System.Data.SqlServerCe.3.5"
<configSections>
<section name="dataConfiguration"
type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
requirePermission="false"/>
</configSections>
<dataConfiguration defaultDatabase="sqlCEDB"/>
<connectionStrings>
<add name="sqlCEDB"
connectionString="Data Source=|DataDirectory|'sqlCEDB.sdf;Password='somepassword'"
providerName="System.Data.SqlServerCe.3.5" />
</connectionStrings>