Menu
I want to add a SQL Server Compact edition in my project in Visual Studio 2013.4, but I don't have the data source in my list:
Also, I don't have System.Data.Sqlce in my assemblies.
How can I add SQL Server Compact data source to my Visual Studio?
477
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.
In Solution Explorer, right-click the WideWorldImporters-SSDT project, click Import, then click Database. In the Import Database window, click Select Connection. In the Connect window, configure your connection properties, then click Connect. In the Import Database window, click Start.
Launch the Visual Studio Installer. In the Windows Start menu, you can search for "installer". In the installer, select for the edition of Visual Studio that you want to add SSDT to, and then choose Modify. Select SQL Server Data Tools under Data storage and processing in the list of workloads.
1: Install the relevant runtime MSI (3.5 SP2 or 4.0) http://www.microsoft.com/en-us/download/details.aspx?id=5783 http://www.microsoft.com/en-us/download/details.aspx?id=30709
2: Install the SQL Server Compact Toolbox VS Extension, and browse to the database file, it will also add the connection to Server Explorer (if you really need that)
101
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
