SQL Server Compact Edition, what's fun about that?
Having SQL Server like capability without the pain of installing SQL Server? Having a solid and supported upgrade path from a local data store to a central shared SQL Server? Having supported multithreaded data storage you can now, with v4, use in your web app? Entity Framework support included in the box? Xcopy deployment of your data and data store? It's free?
Now what about a project that adds a number of tools to Visual Studio that makes using SQL Server Compact 3.5 & 4 even more fun! And what if you could also get the source to that project?
"Version 2.0 of my SQL Server Compact Toolbox extension for Visual Studio 2010 is now available for download. This blog post is a visual guide to the new features included in this release, many suggested by users of the tool via the CodePlex issue tracker.
Full support for SQL Server Compact 4 and the Visual Studio 2010 SP1 Tools for SQL Server Compact 4
The list of databases in the toolbox is now pulled from three sources, Server Explorer connections to 3.5 databases, Server Explorer connections to 4.0 databases, via the new Server Tools for VS 2010 SP1, and finally your own 4.0 connections (VS 2010 SP1 not required)....
SQL Server Compact Toolbox is a Visual Studio 2010 Pro or higher add-in (for 3.5/4.0) and standalone app (for 4.0), that adds scripting, import, export, migrate, rename, run script, manage replication and more to your SQL Server Compact Data Connections in VS Server Explorer.
New release December 2010 - integration with Visual Studio Server Explorer for version 4.0 files, export to SQL Azure, beta of Db Diff, launch from Server Explorer
Please download the Visual Studio add-in (for both 3.5 and 4.0) from Visual Studio Gallery...
- Microsoft SQL Server Compact 4.0 on Microsoft Downloads
- How to Bin Deploy SQL Compact Edition 4.0 and Razor web projects
- Microsoft's Embedded Database - SQL Server Compact - Team Blog
- New Embedded Database Support with ASP.NET
- Announcing release of ASP.NET MVC 3, IIS Express, SQL CE 4, Web Farm Framework, Orchard, WebMatrix
- Entity Framework with SQL Server Compact 4.0 and ASP.NET – Dynamic Data, OData, deployment (part two)