Menu
I have applied Visual Studio 2010 SP1 to my VS2010 Pro. My VS version now says 10.0.40219.1 SP1Rel.
I then downloaded and installed SQL Server Compact Edition 4.0.
However, I still don't see an option for MS SQL Server Compact 4.0. I only see MS SQL Server Compact 3.5.
How can I use SQL Server Compact Edition 4.0 with VS2010?
314
You can open an SDF file with several programs, including Microsoft Visual Studio and LINQPad. To open an SDF file with Visual Studio, select View → Server Explorer → Data Connections → Add Connection..., change the data source to "Microsoft SQL Server Compact," click Browse..., and select the SDF file.
SQL Server 2008 R2 is released Visual Studio 2010 is compatible with SQL Server 2008 R2 so things should just work.
Connect to your database In Visual Studio Code, press Ctrl+Shift+P (or F1) to open the Command Palette. Select MS SQL:Connect and choose Enter.
(1) Open SQL Server Management Studio, or if it's running select File -> Connect Object Explorer... (2) In the Connect to Server dialog change Server type to SQL Server Compact Edition (3) From the Database file dropdown select <Browse for more...> (4) Open your SDF file.
You need to install the tooling and it wil mainly work for web projects. See this blog post: http://erikej.blogspot.com/2011/01/sql-server-compact-40-released.html
101
http://blogs.msdn.com/b/sqlservercompact/archive/2011/03/15/sql-server-compact-4-0-tooling-support-in-visual-studio-2010-sp1-and-visual-web-developer-express-2010-sp1.aspx
Just install Windows Web Platform Installer:
http://www.microsoft.com/web/downloads/platform.aspx
Search for "sp1" and find "Visual Studio 2010" anything mentioning "SQL Compact 4.0" - and install it.
Great tool from Microsoft (the Web Platform Installer), I think.
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
