Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

I thought that Visual Studio 2010 SP1 would include support for using SQL Server Compact Edition 4 inside the designer, but it seems not.

Was I wrong, or has I managed to botch up my installation somehow?

I installed SQL Server CE 4 from the download page, not through the web installer.

If Visual Studio 2010 SP1 does not, and should not, include such support, what are my choices, if any?

share|improve this question
add comment

3 Answers

up vote 4 down vote accepted

Service Pack 1 for Visual Studio 2010 does include a graphical designer, although you need to install additional tools in order to enable this.

It's not as full featured as the experience of using SQL Server Management Studio against a "full" SQL Server or SQL Express database, but nonetheless when enabled it looks like this:

SQL CE 4.0 Editor in Visual Studio 2010 SP1

Scott Guthrie did a blog post regarding VS2010 SP1 and SQL CE a little while ago (when VS2010 SP1 was still in beta). In that post he points to an additional file that is required on top of VS2010 SP1 that enables the tooling support.

Download

You can enable SQL CE tooling support within VS 2010 by first installing VS 2010 SP1 (beta).

Once SP1 is installed, you’ll also then need to install the SQL CE Tools for Visual Studio download. This is a separate download that enables the SQL CE tooling support for VS 2010 SP1.

Note that, at the moment, this tooling seems geared for the BETA version of VS2010 SP1, and the CTP of SQL Server Compact 4.0. I have, however, used this "tooling installation" myself against the "final" version of SQL Server Compact 4.0, and it continued to work.

Hopefully, the SQL CE & Visual Studio teams will do a "refresh" of this additional tooling installation for the final version of VS2010 SP1.

EDIT: A recent ScottGu twitter post has stated that:

We will also have a WebPI package available Monday that auto-installs VS10 SP1 and additional web goodies (IIS Express, SQL CE Tools)

The "Monday" he's talking about should be Monday 14th March 2011, so once that ships, you can download the SQL CE Tools and install them "on top of" the Visual Studio 2010 Service Pack 1, and you'll be good to go with all things SQL Server Compact 4.0 !

share|improve this answer
    
It seems to work nicely in SP1 final as well, tried it. Thanks! –  Lasse V. Karlsen Mar 11 '11 at 7:42
    
@Lasse - Thanks for your comment. It's the one thing I hadn't got round to trying yet (trying the tooling install with SP1 final) and I wasn't sure if I wanted to even install it! I'll wait until Monday myself for the (hopefully) "refresh" that ScottGu mentions. –  CraigTP Mar 11 '11 at 8:53
add comment

Here's a list of 3rd party SQL CE tools, both 3.5 and (some of them) 4.0.

I've been using SQL CE Toolbox from that list which integrates with Visual Studio quite nicely.

share|improve this answer
add comment

Download The management studio.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796

EDIT: You can still use that, then script out the Tables and execute them against CE 4.0.

share|improve this answer
    
This does NOT work with SQL Server Compact 4.0 (in fact, no version of SQL Server Management Studio works with SQL Server Compact 4.0 at the moment!) –  CraigTP Mar 10 '11 at 15:55
    
Oh... he can still use that then script out the Tables and execute them against CE 4.0 –  Morons Mar 10 '11 at 15:59
    
I tried to down vote my self but it didn't let :( –  Morons Mar 10 '11 at 16:02
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.