Steve Lasker August 30, 2007 Uncategorized

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:

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

Steve

10Comments

Add yours

1

MikeH on August 31, 2007 at 8:56 am
Reply

Will ADO.NET EDM Beta 2 support SQLCE 3.5?

LikeLike
2

Dave Michel on October 18, 2007 at 2:55 pm
Reply

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?

LikeLike
3

Steve.Lasker on October 29, 2007 at 11:45 pm
Reply

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

LikeLike
4

Ilan on November 8, 2007 at 6:07 am
Reply

I have a memory corruption error from time to time and its not the ntext field problem are you familiar with this issue ?

LikeLike
5

Steve.Lasker on November 9, 2007 at 8:17 am
Reply

Hi Ilan
We have had some issues with corruption when multiple processes open the same database and one of the processes dies. This gets worse in Visual Studio when we kill debugging during an app update.
We’ve done a number of fixes in 3.5 to minimize this and while we can never gaurentee corruption won’t happen, we’re seeing many of the historical problems are soved. It would be great to download 3.5, give it a try, and let us know. If your still having trouble, we want to know so we can fix the unique situations we’re not seeing.
BTW, RTM is just a few weeks away…
Steve

LikeLike
6

gobledb@hotmail.com on November 16, 2007 at 2:31 am
Reply

"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?

LikeLike
7

Steve.Lasker on November 19, 2007 at 7:05 am
Reply

Hi Kettch,
Yes, sub queries in the FROM clause are in RTM.
Steve

LikeLike
8

Dave Michel on August 4, 2008 at 6:26 pm
Reply

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.
😦

LikeLike
9

Anne on October 7, 2008 at 1:57 pm
Reply

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.

LikeLike
10

Carlos on May 16, 2013 at 12:38 pm
Reply

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,

LikeLike