Which application scenarios are SSCE (SQL Server compact edition) suitable?

In the past, ssce3.5 was initially intended to be used in standalone and embedded systems, and intended to be used as a database system for standalone software or an offline database system for embedded devices.

On this part of the content, mainly seen in: http://www.microsoft.com/china/msdn/library/data/sqlserver/bb380177.mspx? MFR = true

This article also compares other free MS databases in detail, which is a rare article in msdn.

 

In this article, we have mentioned that SSCE can be used for "websites or internal applications with low access traffic", but what truly achieves this goal is ssce4.0. Major improvements of 4.0 include enhancements, tests, integration with ado.net entity, and integration with vs2010 SP1. The author tried to use webmatrix to combine mojoportal and SSCE, which is indeed very easy to use (the actual website is at www.scrum.org.cn, where the database used is ssce4.0 ).

The following article describes ssce4.0's support for this application field.

 

At the end of this article, we mentioned 4.0 that, due to the "rush" to achieve the "simple website" goal, we gave up some content similar to offline data/LINQ support. If you need this content, please go back to SP2 of 3.5: http://www.microsoft.com/downloads/en/details.aspx? Familyid = E497988A-C93A-404C-B161-3A0B323DCE24 & displaylang = en. However, we have not found any support for LINQ. It seems that we have to wait for 4.5. If you need specific functions, read the following two posts carefully.

 

The differences between SSCE and 2005/2008 official versions are as follows: http://msdn.microsoft.com/zh-cn/library/bb896140 (V = SQL .110). aspx