Coffeehouse Thread

41 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

WebMatrix released

Back to Forum: Coffeehouse
  • User profile image
    cbae

    ,exoteric wrote

    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.

  • User profile image
    magicalclick

    @cbae:

    thanks, I am also looking for something like that. It is hard to know what word to search until now.

    Leaving WM on 5/2018 if no apps, no dedicated billboards where I drive, no Store name.
    Last modified
  • User profile image
    cbae

    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.

  • User profile image
    magicalclick

    @cbae:

    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.

    Leaving WM on 5/2018 if no apps, no dedicated billboards where I drive, no Store name.
    Last modified
  • User profile image
    exoteric

    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.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.