Microsoft Sql Server Compact 4.0

Active5 years, 7 months ago
Microsoft

I'm interested in choosing an embedded DB engine for my WPF app. I would like information on how SQLite and latest SQL CE 4.0 compare. And if I should choose one over the other. Points of interest would be ORM support with EF4's CTP & NHibernate 3.

Thanks in advance!

AVP06

SQL Server Compact Edition (currently at version 4.0) is: a free, embedded database that software developers can use for building Windows desktop applications. It has a small footprint and supports private deployment of its binaries within the application folder. But how do you actually deploy it? Support for SQL Server Compact 4.0 on Azure. Ask Question 12. Second Wenchao Zeng of Microsoft the Azure don't support Sql Compact. I could use once but this is not recommended because the Windows Azure work with replication of the data (this is the cloud. I am extremely keen to try out the new version 4.0 of SSCE. However, things seem to be conspiring against this. The best option for me would be for Sql Management Studio to start supporting Sql Server Compact 4.0.

AVP06
5541 gold badge6 silver badges16 bronze badges
  • The SQL Server Compact team is happy to announce that the next version of Microsoft SQL Server Compact 4.0 has been released, and is available for download with the Microsoft Web Platform Installer 3 or from the Microsoft Download Center. SQL Server Compact 4.0 has been designed, developed, tested and tuned over the course of.
  • SQL Server Compact 3.5 SP2 is an embedded database that allows developers to build robust applications for Windows desktops and mobile devices. The download contains the files for installing SQL Server Compact 3.5 SP2 and Synchronization Services for ADO.NET version 1.0 SP1 on Windows desktop.

Microsoft Sql Server Compact 4.0 Sp1 X64 Enu

1 Answer

Microsoft Sql Server Compact 4.0 Service Pack 1 Installation Failed

See this answer: Database functionality with WPF app: SQLite, SQL CE, other? - SQL Compact 4 has full support for Entity Framework, Linq to SQL- Includes all neccesary file for private deployment- has good tools support in Visual Studio 2010 and 2012- has a smooth migration path to SQL Server

Community
ErikEJErikEJ
32.9k3 gold badges51 silver badges89 bronze badges

Not the answer you're looking for? Browse other questions tagged sqlitesql-server-ce or ask your own question.