SQL Server Compact 4.0 Tooling Support in Visual Studio 2010 SP1 and Visual Web Developer Express 2010 SP1

Quick Navigation Links:   Overview   Advantages of using Visual Studio 2010 SP1 or Visual Web Developer Express 2010 SP1 to develop applications for SQL Server Compact 4.0   Visual Studio Designers that do not work with SQL Server Compact 4.0   Fixing installation issues     Overview   The Ultimate, Premium and Professional editions…

0

Microsoft SQL Server Compact 4.0 is available for download

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…

2

Downloads Available for SQL Server Compact 4.0 CTP2, Visual Studio 2010 SP1 Beta Tools for SQL Server Compact 4.0 CTP2, and CMS (mojoPortal, Orchard and Umbraco) that work with SQL Server Compact.

The second community technology preview release of SQL Server Compact 4.0 is available for download from the Microsoft Download Center or as part of the Microsoft WebMatrix Beta 3 in the Microsoft Platform Installer 3.0. To learn more about Microsoft WebMatrix Beta 3 see the WebMatrix Beta Book and video tutorials. An update to the…

0

Introducing SQL Server Compact 4.0, the Next Gen Embedded Database from Microsoft

Microsoft SQL Server Compact 4.0 is the next generation of embedded database from the SQL Server family, and brings all of its goodness to the world of ASP.NET web application development. SQL Server Compact 4.0 will provide an easy and simple to use database storage for starter websites, and the features of Compact that wooed…

0

Troubleshooting: Privately deploying the SQL Server Compact 3.5 SP2 ADO.NET Entity Framework provider (System.Data.SqlServerCe.Entity.dll) in the application folder does not work

For complete instructions about deploying SQL Server Compact ADO.NET Entity Framework provider (System.Data.SqlServerCe.Entity.dll) privately in the application’s folder refer to the blog here. Note that from SQL Server Compact 3.5 SP2 release onwards if you are privately deploying SQL Server Compact 3.5 SP2 DLLs in your application folder you need to copy the managed DLLs…

1

Merge replication vs. Sync Services for Compact

  SQL Server Compact supports predominantly two different sync technologies. “Merge replication” and “Sync Services”. Users might be using one or the other, and interested in knowing the differences between the two technologies, from a use-case point of view. Still, there might be others interested in knowing, which technology better suites their need, by comparing…

0

SQL CE Binaries – Details

  Many times developers get puzzled on which exact set of binaries one should consume in their application.  There is also a misconception that SQL CE engine is too big in size.  This may be because there was no effort from our side to clarify on “Which binary is for what purpose?”.  In an effort…


SQL Server Compact Garbage Collection – Whys and Hows

Some background about SQL Server Compact: SQL Server Compact is an embedded database implemented in native and it can be accessed in application by either OLEDB or ADO.NET provider model. ADO.NET provider for SQL Server Compact is a managed assembly which depends on native SQL Server Compact DLLs to provide the service. In general, the…

0