Skip to content

Steve Lasker

Main navigation
  • Home
  • Contact
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

Share this:

  • Twitter
  • Facebook

Like this:

Like Loading...

Related

Posted in Uncategorized. Bookmark the permalink.

10Comments

Add yours
  1. 1
    MikeH on August 31, 2007 at 8:56 am
    Reply

    Will ADO.NET EDM Beta 2 support SQLCE 3.5?

    LikeLike

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

Leave a Reply Cancel reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

Blog at WordPress.com.
  • Home
  • Contact
Secondary navigation
  • Home
  • Contact
  • Search

Post navigation

DevConnections Does Data
Heading to Barcelona for Tech Ed ‘07

Begin typing your search above and press return to search. Press Esc to cancel.

  • Follow Following
    • Steve Lasker
    • Already have a WordPress.com account? Log in now.
    • Steve Lasker
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Copy shortlink
    • Report this content
    • View post in Reader
    • Manage subscriptions
    • Collapse this bar
%d bloggers like this: