I suggest you ...

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

1,561 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Mojtaba KavianiMojtaba Kaviani shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    95 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Burak AktayBurak Aktay commented  ·   ·  Flag as inappropriate

        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?

      • OxibaOxiba commented  ·   ·  Flag as inappropriate

        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!

      • AndyAndy commented  ·   ·  Flag as inappropriate

        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.

      • GeorgeGeorge commented  ·   ·  Flag as inappropriate

        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!

      • ErikEJErikEJ commented  ·   ·  Flag as inappropriate

        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

      • BillyBilly commented  ·   ·  Flag as inappropriate

        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 PreussMaik Preuss commented  ·   ·  Flag as inappropriate

        Sql Server Compact Supports NaN and Infinity Values. SQL Server Express does not. This is a show stopper for my report application.

      • wavemasterwavemaster commented  ·   ·  Flag as inappropriate

        I also vote to have full sql CE support in 2013 and any upcoming version.

        We need to ask ourselves why this is happening. My theory is the folks at Microsoft are not involved with a long term effort that requires stability and maintainability.

        They appear to be writing tutorials and for that a new tool every now and then is really cool.

      • WildwylieWildwylie commented  ·   ·  Flag as inappropriate

        Please bring it back, I try ErikEJ add-on and have not been able to get SQL server CE working, it was so much easier when it was a part of Visual Studio. Sorry Erik I just don't get it...No offense

      • Anonymous commented  ·   ·  Flag as inappropriate

        We need some file-based, lightweight options for when there is no SQL Server instance available. Don't make us go back to using Access Databases for this!

      • CesarCesar commented  ·   ·  Flag as inappropriate

        LocalDb is not a replacement for the SQL CE. SQL CE is embeddable, while LocalDb is not.

        I dont't think they could deprecate something while there are no substitute to that.

        Make LocalDb embeddable or bring SQL CE back please.

      ← Previous 1 3 4 5

      Feedback and Knowledge Base