My Visual Studio 2010 add-in for SQL Server Compact 3.5 has just been updated. The new version 1.2 contains the following new features and fixes a bug:
- Parse and Show Estimated Plan features to editor
- improved DGML diagram (table fields with various info added)
- check for newer version on load
- BUG: Identity columns were ignored in scripts
Download the latest version from here: http://visualstudiogallery.msdn.microsoft.com/en-us/0e313dfd-be80-4afb-b5e9-6e74d369f7a1
SQL editor improvements
To show the Estimated Execution Plan, you must either have Visual Studio 2010 Premium or Ultimate installed. If you are using Visual Studio 2010 Professional, you must have SQL Server Management Studio installed to see the graphical execution plan.
Improved DGML diagram
In addition to showing table relationships, the generated DGML diagram (which you can view in Visual Studio 2010 Premium or higher) now contains all table fields and a visual indication if a field is either a primary key, a foreign key, optional (NULLable).
If the add-in has been updated, you will get a visual indication, and a link to the CodePlex site.