How can I connect to a SQL Server Compact 3.5 file as a data source in Visual Studio 2012?
Visual Studio 2012 comes with SQL Server Compact 4.0. I have installed SQL Server Compact 3.5 from http://www.microsoft.com/en-GB/download/confirmation.aspx?id=5783 However I still only have the option of making a new data connection to a SQL Server Compact 4.0 file, whereas the files I need to get data from are SQL Server Compact 3.5 files.
Is it possible to connect to a SQL Server Compact 3.5 file as a data source in Visual Studio 2012? If so which settings or installs should I need?
Over in a thread I started on SQL Server Developer Center > SQL Server Forums > SQL Server Compact Ray Chen has posted an answer:
Unfortunately, SQL Server CE 3.5 is not supported in VS 2012 indeed. You have to upgrade the SQL Server CE 3.5 database to 4.0 as Erik suggested [link added]. Also please take a look at this article: Visual Studio 2012 Compatibility. In the section of ‘These Assets Need Your Attention’, it says: One-way upgrade. You must upgrade these assets before you can open them in Visual Studio 2012. After you upgrade, you won’t be able to open them in previous versions. The following table lists the project types, file types, and technologies that you must upgrade. And SQL Server CE 3.5 is included in the table.
I've posted a subsidiary question there to find out how, given that I cannot read in the file, I would convert it to SQL Server Compact 4.0.
=========== EDIT ==========
Ray Chen went on to post references to ErikEJ's blog post HOW TO: Upgrade a version 3.x database file to SQL Server Compact 4.0 and to the SqlCeEngine.Upgrade Method (String) library page.
- Compile a Solution in VS Express which was written in VS Professional
- Can't commit changes to GitHub in Visual Studio
- Compiling MySQL custom engine in Visual Studio 2008
- How do I know if a vector function (SIMD) really worked on multiple objects at a time?
- QMAKE *.pro-file: enable debugging info in release mode
- Visual Studio ASP.NET Core Debug IIS Express - Site can't be reached
- Cannot open include file: No such file or directory, but it exists in Additional Include Directory
- Difference between compiling as C# 3.0 or ISO-1 or ISO-2?
- Publish .net MAUI Application as windows executable
- Visual Studio - Proxy Authentication Required - Connecting to packages.nuget.org
- Error: Registration of the app failed
- Open a folder in Visual Studio
- How to create and use resources in .NET
- How to reduce the size of .exe when publish it to folder as single file
- Selecting a compiler for a make file
- Multiple build actions per file in Visual Studio
- ASP.NET MVC: how to signal compilation error if a view has error?
- Visual Studio thinks my controls are missing, but they're not. "The name xx does not exist in the current context"
- Why my inheritance is not getting green? Such as CharacterManager class, which is another script
- Switch between my google accounts using selenium from c#
- Is there a way to join (link?) a managed (.net) dll at compile time?
- dll file or .exe file is missing
- Changing compiler
- Error Unable to start debugging on the web server
- How do I view GitHub issues from within Visual Studio 2022?
- What is the benefit of using std::copy instead of manual for loop to copy dynamic array?
- Is there easily achievable debugging from Visual Studio with multiple symbols (stripped vs full)?
- Visual Studio Team Explorer - GIT: Automatically ignoring new files
- How can I disable the Yellow Highlighting of @ in Blazor Visual Studio?
- Breakpoints and Bookmarks no longer appear in gutter in Visual Studio 2022