Partilhar via


SQL Server Compact 3.5 Features

Ambrish, one of our great Program Managers for SQL Server Compact has posted some details on the 3.5 enhancements:

https://blogs.msdn.com/sqlservercompact/archive/2007/08/30/sql-server-compact-3-5-beta-2-downloads.aspx?CommentPosted=true#commentmessage

Steve

Comments

  • Anonymous
    August 31, 2007
    Will ADO.NET EDM Beta 2 support SQLCE 3.5?

  • Anonymous
    October 18, 2007
    I'm working with 3.5 Beta 2, and am finding that a subquery in a SELECT clause still doesn't seem to be supported. Am I wrong, or is this functionality still not part of CE 3.5 Beta 2?

  • Anonymous
    October 29, 2007
    Looks like Sub Query didn't make Beta 2.  RTM is just around the corner, so just hang in there just a little bit longer... Steve

  • Anonymous
    November 07, 2007
    I have a memory corruption error from time to time and its not the ntext field problem are you familiar with this issue ?

  • Anonymous
    November 09, 2007
    The comment has been removed

  • Anonymous
    November 15, 2007
    "Looks like Sub Query didn't make Beta 2.  RTM is just around the corner, so just hang in there just a little bit longer..." Just to be clear, subqueries will be in RTM?

  • Anonymous
    November 18, 2007
    Hi Kettch, Yes, sub queries in the FROM clause are in RTM. Steve

  • Anonymous
    August 04, 2008
    Any examples of how to do a subquery in the FROM clause (or any other clause) in CE 3.5 RTM? I can only get a WHERE IN to work. :-(

  • Anonymous
    October 07, 2008
    is this SQL is supported in the version of SQLCE select i.ID, (Select Sum(Amt) from t2 p where p.ID = i.ID) as UnpaidAmt from t1 i Thanks.

  • Anonymous
    May 16, 2013
    Hi Steve. We are developpers for mobile devices and we found SQL CE 3.5 SP2 with a problem in the method INSERT when the DB connection is being closed. We didn't find anything weird about how the code is wrote but the problem is hugh and we found also several reports about problems with the INSERT method. connect.microsoft.com/.../sql-server-compact-edition-sql-ce-hangs-in-sqlceconnection-close-caused-by-gc-waitforpendingfinalizers Do you know where we can find updating to solve those issues? Thank you,