Coffeehouse Thread

10 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

SQL CE in Silverlight?

Back to Forum: Coffeehouse
  • User profile image
    dougwalker

    Has anyone heard any news about Silverlight 5 including SQL CE for local database support? If WP7 is getting it in Mango, why wouldn't they put it into Silverlight 5? OK...I guess porting SQL CE to mac might be a big deal...but still, local database support would certainly simplify some tasks.

    Anyone heard anything?

  • User profile image
    JoshRoss

    I haven't seen anything about SQL anything getting included with Silverlight. Erik Meijer has put together some fascinating analysis of the duality of SQL and NoSQL.

    Since there is all this NoSQL stuff baked-in to the runtime, I can only hope that more of the SQL parts make it in, sooner than later. There are some tasks that become much easier to solve when you can leverage a SQL database. 

    I would like to think of this inclusion as some type of parity of duality, at least at the feature subset of the toolset.

    -Josh

  • User profile image
    spivonious

    I don't understand the hubbub over local Silverlight apps. Why not just use WPF?

  • User profile image
    Dr Herbie

    @spivonious: Because the exact same code can be build for desktop or browser (and they both look the same);  really useful for distributed companies like our customers.

    Herbie

     

    EDIT : Not that we're using Silverlight, having so much business logic coded up in our windows forms ( Mad )

  • User profile image
    magicalclick

    @JoshRoss:

    Regardless which side to take SQL/noSQL, there are need for relation tables to store data. So, I aggree with TC, we need it. I hope they take out the artificial 4GB limitation though, it is quite disappointing when I actually need more than 4GB in my research and using multiple files is not an option.

    Leaving WM on 5/2018 if no apps, no dedicated billboards where I drive, no Store name.
    Last modified
  • User profile image
    JoshRoss

    @magicalclick: Who is TC? 

  • User profile image
    magicalclick

    topic creator.

    Leaving WM on 5/2018 if no apps, no dedicated billboards where I drive, no Store name.
    Last modified
  • User profile image
    kettch

    @magicalclick:Interesting. That's the first time I've seen that convention. Usually it's OP (Original Poster).

  • User profile image
    ErikEJ

    You can access SQL Server Compact from Silverlight (Windows only, don't count on a Mac port evar) today - see http://erikej.blogspot.com/2010/02/access-local-sql-compact-database-from.html

    Microsoft .NET Dev & Data Platform MVP, creator of SQLite / SQLCE Toolbox, Entity Framework guru
    Last modified
  • User profile image
    vesuvius

    @magicalclick: I think with SQL express the limit has been increased to 10 gig so hope the same gose for SQL Compact.

    That said if you have that much data, your really need something beefier to handle accessing the records. I know the limit is seen as forcing people to get expensive SQL licenses, but I am sure there are performance implications for using such a lightweight database with that much data.

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.