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:
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... SteveAnonymous
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 removedAnonymous
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. SteveAnonymous
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,