SQL Server CE 4.0 addin not working with VS2013

1
votes

Need help for adding SQL Server CE database to WPF desktop application. I am using VS 2013 professional preview.

I've tried installing the SQL Server CE toolbox add-in, but that toolbox is not allowing me to add SQL Server CE 4.0 connection. I am not allowed to post the image being a less reputed guy, else I would have shown the snippet of VS. Is the toolbox not supported in VS 2013 ?

Also just wanted to know, using SQL Server CE would be a good idea to use as a database for desktop application assuming that my database may have around 10million rows (max.)

1
wpfsql-server-ce
Also the toolbox shows runtime 3.5 not found - zomato
for now you have to install sql ce 3.5 for the toolbox. - Brady Moritz

1 Answers

1
votes

The SQL Server Compact Toolbox works with and is fully supported with Visual Studio 2013, but it requires either the 3.5 SP2 or 4.0 SQL Server Compact runtime to be installed. See this for more info and download links: https://sqlcetoolbox.codeplex.com/documentation (I am the author of the Toolbox)