locked
What kind of local database options are available in Metro style app? RRS feed

  • Question

  • I am in the process of developing a small app that requires local db preferred sql ce or similar. So far my understanding is that sql server isn't an option if so than what local db option is available?

    If my application has to have a database then what are my options for online db? My worries with online db is the internet connection isn't always live

      
    Saturday, June 9, 2012 2:29 AM

Answers

  • Yes, SQLite will pass store certification as long as compiled correctly.  The current binaries on the SQLite site aren't the ones built for WinRT, but you can build it yourself and use it.

    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    • Marked as answer by ScanSoftPOS Sunday, June 10, 2012 4:06 AM
    Saturday, June 9, 2012 4:53 AM

All replies

  • There aren't any SQL-like databases provided in-box, but you can use a 3rd party database such as SQLite. For online databases you can connect to anything available over the network.

    --Rob

    Saturday, June 9, 2012 4:34 AM
    Moderator
  • anything that will pass validation with app submission? So will sqllite pass app submission guidlines

    • Proposed as answer by Ilija17 Monday, June 2, 2014 4:05 PM
    Saturday, June 9, 2012 4:47 AM
  • Yes, SQLite will pass store certification as long as compiled correctly.  The current binaries on the SQLite site aren't the ones built for WinRT, but you can build it yourself and use it.

    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    • Marked as answer by ScanSoftPOS Sunday, June 10, 2012 4:06 AM
    Saturday, June 9, 2012 4:53 AM
  • Another option would be Siaqodb- NoSql database: http://siaqodb.com/?p=818
    Saturday, June 23, 2012 8:35 AM
  • Hi Tim

    since you are within the inner circle of Microsoft, why sql ce is not qualified to be used as local db for window8 apps?

    why we have to use 3rd party tools? can't Microsoft certified your own product (LocalDB for ex)? but can for SQLite?

    something wrong i would say.  SQLCe can be use for Window Service, EF, Web apps, WIndow Form , WPF but not win8 Apps?


    Saturday, October 19, 2013 5:28 AM
  • Saturday, October 19, 2013 2:26 PM
  • you can also use essent database, the one build in windows but you need to interop with system32 dlls

    Microsoft Certified Solutions Developer - Windows Store Apps Using C#

    Saturday, October 19, 2013 4:19 PM
  • ManagedEssent provides C# wrapper, so interop is not required - http://managedesent.codeplex.com/

    Blog: http://lunarfrog.com/blog

    Sunday, October 20, 2013 3:43 PM
  • SQLCE uses a lot of surface area to run and requires some "server" components to run/exist on the machine.  That model doesn't match with the confidence model of the WinRT appcontainer.  We also see a lot of customers wanting a lot of data portability across a lot of devices and SQLite was the clear leader in this space.  This is why we worked with them to ensure it did work within WinRT and they now release a version certified for WinRT apps.  Likewise the Phone recommends this database as well.

    Tim Heuer | Program Manager, UI Platforms (XAML, WinJS) | http://timheuer.com/blog | @timheuer | Callisto - XAML UI Toolkit

    (if my post has answered your question, please consider using the *mark as answer* feature in the forums to help others)

    Monday, October 21, 2013 2:03 AM