Support Sql Server Compact in Visual Studio 2013
please bring back visual studio 2013 tools for sql server compact and improvement capebilities of tools and sql server compact. please add trigger and prosedual sql feature to sql server compact. over milion application data stored in sql server compact database and need continue supporting this tools
Soran Singh commented
It is really too hard to use SQL CE 4.0 with Visual Studio Community 2015 in comparison to VS 2010. Not a single data designer is supporting SQL CE 4.0 database in VS 2015. I have to hard code data connection string in data source every time and even you can`t test your SQL query or even establish a connection. So what is purpose of dropping the data tool support for SQL CE 4? It is far better to use Visual Studio 2010. Every one can`t afford SQL Server or any other database. If I have to develop some data application for mobile, what is option left for us in Visual Studio 2015 by Microsoft? this is a basic need of so many developers to bring back SQL CE data tools for VS 2015. Single third party tool (ErikEJ) is inadequate to serve purpose of many developers till VS server explorer does not support data connections for SQLCE. It will a boon to small developers if Microsoft can bring back SQL CE Tools for VS 2015.
First you stop support for MS Jet usign mdb files.
Then you stopped support for SQL CE using SDF files.
So what is the alternative DB for small desktop Apps?
Please bring back support or continue support for SQL CE. it was easy to use DB for desktop Apps. A migration to SQLlite seems to be the only workaround.
Visual Source Safe was born handicapped and deserved to die. Silverlight is terminally ill. SQL VARDECIMAL storage born 2005, died 2008. Zune (what?) is in an unmarked grave. Nokia phones are being embraced, extended and extin.. (choke aargh)
But SQL CE on the other hand, is healthy, vital and strong. Now you wanna give it the lethal injection? How's your head, MS?
If Microsoft depreceates something so valueable, then it should explain, why and what is the long term strategy behind it. If Microsoft thinks, that there are much better alternatives in the market today, then they should point out, which ones are better today. For example, to kick Silverlight was clear to everybody, years before the official kick came.
I think Microsoft should offer at least 2 DB systems: SQL Server/Express for the corporate market and a serverless DB for small desktop application. I am asking you: Who wants a desktop application, that installs a DB server on a normal Windows client or a phone? That is absurd.
Bring back SQL Server Compact!
In an super ideal world, the Entity Framework 6.x would support SQL Server and SQL Compact, so that you just had to change the connection string, to point to one of these DBs.
please Microsoft, bring back SqlServer Compact
Why deprecate something so handy to use
Burak Aktay commented
NuGet has Entity Framwork for Compact 4.0 but when added old connection string format does not work. Interface for sqldatasource connectionstring has changed. I could not get it to work with VS2013 FW4.5. What happened to Microsofts backward compatibility principals?
I have to agree.
please bring back visual studio 2013 tools for sql server compact
Really it is disappointing, It would certainly leverage the uses of SQL LITE and other open alternatives.
Let´s bring back the Compact SQL, please!
I agree. I am in the middle of a big project using VS2013 where I need to store a few hundred records of organised data - Yes I thought, SQL Compact/CE, as everything is bundled into the app and when the time comes its an easy migrate to SQLServer. It uses almost the same T-SQL we know, has almost the same database schema capabilities, and your could open it up in SQL management studio. Why remove something that gives the developer an easy migration route to SQL Server.
Until we have this I have no choice but to drop back to VS2010, or look for another product that provides a fully self contained database ability. Who knows - if I find an alternative I like I may just decide to drop the SQL server integration within all our systems.
Yes.... I loved that was easy to deploy and all of a customers data was in one file. I've seen professional programming teams that I managed struggle to get SQL proper to install, uninstall and reinstall properly on many customer equipment. Which made very expensive to buy tool a pain in the #@%$. I've seen small developers struggle with many customers having problems with MS Jet databases. MS finally got it right with SQL CE..... so naturally the next thing they do is to mess it up. I'd rather roll back my dev tools and not use the latest VS rather than go away from using SQLCE. In fact, I'm done wasting time with this and proceeding to uninstall the latest VS right now. Fools!
Please add it back!!!!!
why remove it? really trouble
Please add it back !
You can use my free SQL Server Compact Toolbox add-in. If you miss anything or it does not Work for you, please let me know via the issue tracker på Codeplex
IBM lost itself in the corporate world, opening a gap for the PC and Microsoft to move in, making computing available to the man in the street. Now history seems to be repeating itself with Microsoft itself getting lost in the corporate world.
The man in the street applications don't want to have to install other stuff like SQL Server to be able to run. Having to install the correct version of the dot net framework is complicated enough. The compact model was ideal. Simply copy the executable and a data file and you're done (except for the correct version of the dot net framework of course).
Maik Preuss commented
Sql Server Compact Supports NaN and Infinity Values. SQL Server Express does not. This is a show stopper for my report application.
Please bring it back