The biggest downside I've seen so far is the very primitive database support; there are arbitrary restrictions that make the GUI management of the database schema very prohibitive and counter-productive. Simple things like renaming columns and deleting colums with relations or adding columns with non-nullability is often not possible.
There's a Visual Studio extension called SQL Server Compact Toolbox. This extension allows you to connect to SQL Server Compact 3.5 or 4.0 database files from VS2010. You can generate and run CREATE and DROP scripts as well as run SELECT, UPDATE, and DELETE statements. AFAIK, there is no visual table designer. You'd still have to use the one in WebMatrix, but if you wanted generate the entire schema from a script, you can run the script through the SSCT in Visual Studio instead of having to design the tables manually with the WebMatrix table designer.
thanks, I am also looking for something like that. It is hard to know what word to search until now.
I forgot to mention that you'll also need Visual Studio SP1 Tools for SQL Server Compact 4.0, which allows you to add the data connection in Server Explorer of Visual Studio. It has the tooling to visually design tables as well. I haven't played with the WebMatrix table designer too much, but the designer in Tools for SSC 4.0 looks more like the designer in SSMS, which is what I'm used to.
The Tools for SSC 4.0 can be installed from the Web Platform Installer.
The SSC Toolbox can be installed from the Extension Manager in VS.
thanks. I am currently using the stand alone version. Strangely I cannot add more columns. But, since I can run the query scripts, I guess I can do it by hand using modified scripts.
Actually VS: Pro works quite well too, but, this toolbox has the Script generator, which is what I need during my table designs. I like to move the columns around before finalizing ti.
Yeah, first looked at some SQL CE tools on Codeplex but they are either buggy, very limited or simply don't run. I've tried the SQL CE Toolbox after that but in the end I switched to just using T-SQL which sadly ended up being more productive than using the GUI tools.
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.