将实体框架与 SQL Compact 私有安装一起使用 [英] Using Entity Framework with an SQL Compact Private Installation

问题描述

我在带有 SQL Compact 的桌面应用程序中使用 Entity Framework 4.我想在我的应用程序中使用 SQL Compact 的私有安装，这样我的安装程序就可以安装 SQL Compact，而无需让用户进行第二次安装.它还避免了以后的版本问题.

I am using Entity Framework 4 in a desktop application with SQL Compact. I want to use a private installation of SQL Compact with my application, so that my installer can install SQL Compact without giving the user a second installation to do. It also avoids versioning hassles down the road.

我的开发机器安装了 SQL Compact 3.5 SP1 作为公共安装，所以我的应用程序在那里运行良好，正如人们所期望的那样.但它没有在我的测试机器上运行，它没有安装 SQL Compact.我收到此错误:

My development machine has SQL Compact 3.5 SP1 installed as a public installation, so my app runs fine there, as one would expect. But it's not running on my test machine, which does not have SQL Compact installed. I get this error:

The specified store provider cannot be found in the configuration, or is not valid.

我知道有些人在使用 SQL Compact 私有安装时遇到困难，但是 我已经使用过它们有一段时间，我真的很喜欢他们.不幸的是，我的常规私人安装方法不起作用.我查了一下SQL CE文件的版本号，都是3.8.8078.0，是SP2 RC版本.

I know some people have had difficulty with SQL Compact private installations, but I have used them for a while, and I really like them. Unfortunately, my regular private installation approach isn't working. I have checked the version numbers on my SQL CE files, and they are all 3.8.8078.0, which is the SP2 RC version.

以下是我在私人安装中包含的文件:

Here are the files I have included in my private installation:

• sqlcecompact35.dll
• sqlceer35EN.dll
• sqlceme35.dll
• sqlceqp35.dll
• sqlcese35.dll
• System.Data.SqlServerCe.dll
• System.Data.SqlServerCe.Entity.dll

我已经在我的项目中添加了对 System.Data.SqlServerCe 的引用，并且我已经确认上面列出的所有文件都被复制到安装机器上的应用程序文件夹中.

I have added a reference to System.Data.SqlServerCe to my project, and I have verified that all of the files listed above are being copied to the application folder on the installation machine.

这是我在打开 SQL Compact 文件时用于配置 EntityConnectionStringBuilder 的代码:

Here is the code I use to configure an EntityConnectionStringBuilder when I open a SQL Compact file:

var sqlCompactConnectionString = string.Format("Data Source={0}", filePath);

// Set Builder properties
builder.Metadata = string.Format("res://*/{0}.csdl|res://*/{0}.ssdl|res://*/{0}.msl", edmName);
builder.Provider = "System.Data.SqlServerCe.3.5";
builder.ProviderConnectionString = sqlCompactConnectionString;
var edmConnectionString = builder.ToString();

我是不是遗漏了一个文件?我是否缺少告诉 Entity Framework 在哪里可以找到我的 SQL Compact DLL 所需的配置步骤?为什么 EF 在安装机器上找不到我的 SQL Compact DLL 的任何其他建议?感谢您的帮助.

Am I missing a file? Am I missing a configuration stepp needed to tell Entity Framework where to find my SQL Compact DLLs? Any other suggestions why EF isn't finding my SQL Compact DLLs on the installation machine? Thanks for your help.

推荐答案

我想出了怎么做，感谢 Steve Lasker 的博客文章.基本上，您必须执行以下操作:

I figured out how to do it, thanks to a blog post by Steve Lasker. Basically, here is what you have to do:

(1) 在您的项目中设置对System.Data.SqlServerCe.dll 的引用.将 CopyLocal 属性设置为 True.

(1) Set a reference to System.Data.SqlServerCe.dll in your project. Set the CopyLocal property to True.

(2) 在您项目的 App.config 中，添加以下 XML 标记.它告诉 EntityFramework 为它的数据提供者查找您的 SQL Compact 私人安装:

(2) In the App.config for your project, add the following XML markup. It tells EntityFramework to look to your private installation of SQL Compact for its data provider:

<system.data>
    <DbProviderFactories>
        <remove invariant="System.Data.SqlServerCe.3.5"/>
        <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
    </DbProviderFactories>
</system.data>

(3) 在 Setup 项目中，将以下文件添加到文件系统编辑器的应用程序文件夹中:

(3) In the Setup project, add the following files to the Application Folder in the File System Editor:

• sqlcecompact35.dll
• sqlceme35.dll
• sqlcese35.dll
• System.Data.SqlServerCe.Entity.dll

这篇关于将实体框架与 SQL Compact 私有安装一起使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！