背景 - 如果我建立一个WPF桌面应用程序（VS2010和放大器; .NET 4中），并想一个轻量级的数据库来使用，但不必拥有一个单独的安装。 SQLite的将是从我读，但是我想这将是很好的坚持与微软位，并尝试使用SQL Server CE确定。

Background - If I am building a WPF desktop application (VS2010 & .NET 4) and would like a lightweight database to use but without having to have a separate installation. SQLite would be OK from what I read however I was thinking it would be good to stick with the Microsoft bits and try to use SQL Server CE.

问题 - 是否SQL Server CE的需要安装单独到我的WPF应用程序的安装？或者它只是要求我创建数据库（我可以）在VS2010，并确保相应的DLL包含在应用时，它的部署？我看的多科在下面的链接，这不是很清楚，我...

Question - Does SQL Server CE require an "installation" separate to my WPF application's installation? Or does it just require me to create the database (as I can) within VS2010 and ensure the appropriate DLL is contained in the application when it's deployed? I'm looking at the doco at the following link and it's not clear to me...

http://technet.microsoft.com/ EN-US /库/ bb190958（SQL.100）的.aspx

感谢

PS。我看到另一个令人担忧的项目是：如果你安装了Windows XP SP2，使用SQL Server精简连接，您必须启用HTTP访问的默认设置为禁用HTTP访问。，从页面的 http://technet.microsoft.com/en-us/library/ms171869（SQL.100 ）的.aspx 所以希望这是不是另一种并发症能够使用CE没有安装问题/做文章？

PS. Another worrying item I see is "If you install Windows XP SP2, to use SQL Server Compact connectivity, you will have to enable HTTP access. The default setting is to disable HTTP access", from the page http://technet.microsoft.com/en-us/library/ms171869(SQL.100).aspx So hopefully this is not another complication to being able to use CE with no installation issues/fuss?

推荐答案

Sql Server的CE版本4将不要求安装，但它尚未发布（甚至没有一个测试版）。你可以阅读更多关于它在这里：新的嵌入式数据库支持与ASP.NET

Sql Server CE version 4 will not require installation but it has not been released yet (Not even a beta). You can read more about it here: New Embedded Database Support with ASP.NET

如果我是你，我只想坚持使用SQLite。它是免费的，拥有一支优秀的.NET提供程序与实体框架的支持，是真快。

If I were you I would just stick with Sqlite. It's free, has an excellent .Net provider with Entity Framework support and is really fast.