Compact Edition vs Express Edition

Difference Between SQL Server Compact Edition and SQL Server Express Edition

S.No	SQL Server Compact Edition	SQL Server Express Edition
1	Privately installed, embedded, with the application: Yes	Privately installed, embedded, with the application: No
2	Non-admin installation option: Yes	Non-admin installation option: No
3	Runs on Windows Mobile platform: Yes	Runs on Windows Mobile platform: No
4	Runs in-process with application: Yes	Runs in-process with application: No
5	Runs as a service: No	Runs as a service: Yes
6	File format: Single File	File format: Multiple Files
7	Data file storage on a network share: Yes	Data file storage on a network share: No
8	Support for different file extensions: Yes	Support for different file extensions: No
9	Procedural T-SQLSelect Case, If, features: No	Procedural T-SQLSelect Case, If, features: Yes
10	Remote Data Access (RDA): Yes	Remote Data Access (RDA): No
11	Distributed transactions: No	Distributed transactions: Yes
12	Stored procedures, views, triggers :No	Stored procedures, views, triggers : Yes
13	Role-based security: No	Role-based security: Yes
14	Number of concurrent connections: 256	Number of concurrent connections: Unlimited