What are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)

What are the limitations to SQL Server Compact? (Or - how does one choose a database to use on MS platforms?)

sql-server database visual-studio-2008 sql-server-ce

database

Create SQL Server CE database file programmatically

c# .net sql-server database sql-server-ce

database

How do you create a foreign key relationship in a SQL Server CE (Compact Edition) Database?

database visual-studio sql-server-ce visual-studio-2005

database

Create .mdf/.sdf database dynamically

c# sql-server database sql-server-ce dynamically-generated

database

Inserting a large number of rows into SQL CE 4.0 with Entity Framework 4 (performance issue)

c# database entity-framework-4 insert sql-server-ce

database

Local DB throws Byte array truncation to a length of 8000 exception

database windows-phone-7 linq-to-sql sql-server-ce

database

Has anyone used (or considered using) Sql Server Compact Edition? [closed]

sql-server database windows-mobile sql-server-ce

database

Advantages and Disadvantages of SQLite.NET and SQL Server Compact

database sqlite sql-server-ce system.data.sqlite

database

Do Windows 8 Metro style application support SQL Server CE local database?

database windows-8 sql-server-ce windows-store-apps

database

Can I access sdf (SQL Server Compact database file) kept at some other computer on the same network?

c# database sql-server-ce connection-string

database

.CSV to SQL CE Table?

c# sql database visual-studio-2010 sql-server-ce

database

Microsoft Azure HIPAA Database Compliance

database azure sql-server-ce

database

jdbc driver for Microsoft SQL Server CE(Compact Edition) 3.5

java sql-server database jdbc sql-server-ce

database

exception with Linq to SQL using sdf file

c# .net sql database sql-server-ce

database

Create database file (.sdf) if doesn't exists?

c# database visual-studio-2010 sql-server-ce

database