问题描述
- 在用微软企业库连接SqlServerCe不成功
- 我在项目中用微软企业库的方式连接SqlServer Ce不成功,但是连接MSSQL没问题;
我想知道微软企业库是否能连接SqlServer Ce;配置文件
<add name=""CS_Telecom"" connectionString=""Data Source=D:EWS_ProjectDataBaseMyDatabase#1.sdf;Password=123456"" providerName=""Microsoft.SqlServerCe.Client""/>
代码
public virtual void CreateDatabase() { if (string.IsNullOrEmpty(DBName)) { this.db = Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(); } else { this.db = Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase(DBName); } }
错误信息
Activation error occured while trying to get instance of type Database key ""CS_Telecom""
解决方案
把配置文件改成,就解决了
<add name=""CS_Telecom"" connectionString=""Data Source=D:EWS_ProjectDataBaseMyDatabase#1.sdf;Password=123456"" providerName=""System.Data.SqlServerCe.3.5""/>
解决方案二:
providerName=""System.Data.SqlServerCe.3.5""
时间: 2024-04-25 01:17:38