SQL LocalDB与SQL Server CE [英] SQL LocalDB vs SQL Server CE

问题描述

我有一个小型项目，1台电脑上有1个用户。数据库将相当小（可能少于1 MB的数据）。我计划为该项目使用WPF和实体框架。

我为我的项目提出了两个潜在的数据库解决方案： SQL Server CE 和 SQL Server Express LocalDB （带有SQL Server 2012）。我从来没有使用任何这些，我更习惯于使用完整的SQL Server 2008安装。

我也希望在客户端上轻松安装。理想情况下，我想把一堆文件放在一个文件夹（和我的.exe文件一起）。

所以这里的任何人都可以建议我使用最好的技术

谢谢！

解决方案

请参阅介绍SQL Server Express本地数据库运行时演示文稿 - 提供了一个很好的概述。

LocalDB的巨大优点是它是真正的SQL Server - 它是SQL Server Express的一个特殊版本，但它基本上支持真正的SQL Server所有的一切 - 空间数据类型，存储过程 - 你命名它。 >

另一方面，SQL Server Compact Edition是一个非常大的缩减版本 - 不支持许多功能和数据类型。它更小，更敏捷 - 但它缺乏很多的打击。

我个人将选择SQL Server Express与SQL Server CE 4的LocalDB运行时 - 除非你特别需要SQL Server CE的小尺寸（例如在移动设备上）。

另请参阅之间的比较ErikEJ的优秀<所有SQL Server Compact 网站。

I have a small project that will have 1 user on 1 computer. The database will be rather small (probably less than 1 mb of data). I plan to use WPF and Entity Framework for that project.

I came up with 2 potential database solutions for my project : SQL Server CE and SQL Server Express LocalDB (with SQL Server 2012). I have never worked with any of those, I'm more used to work with the full SQL Server 2008 installation.

I also want it to be easy to install on the client. Ideally I'd like to just throw a bunch of files on a folder (along with my .exe file).

So anybody here could suggest me the best technology to use?

Thanks!

解决方案

See the Introducing SQL Server Express Local DB Runtime presentation - gives a great overview.

The huge benefit of LocalDB is that it's real SQL Server - it's a special version of SQL Server Express, but it basically supports everything that "real" SQL Server has - spatial data types, stored procedures - you name it.

SQL Server Compact Edition on the other hand is a very much scaled down version - lot of features and datatypes aren't supported. It's smaller and more "agile" - but it lacks a lot of punch.

I personally would pick SQL Server Express with the LocalDB runtime over SQL Server CE 4 - unless you specifically need the tiny size of SQL Server CE (e.g. on a mobile device).

Also see a comparison between SQL Server CE 3.5, CE 4.0, SQL Server Express 2008 R2 and SQL Server 2012 Express LocalDB on ErikEJ's excellent Everything SQL Server Compact web site.

这篇关于SQL LocalDB与SQL Server CE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！