locked
[WINDOWS STORE APP] - Reading an Access DB from C# RRS feed

  • Question

  • Hi everyone!

    As the title says, I'm developing an app for Windows Store (actually I'm porting from XNA to Monogame).

    My project used to read some of its contents from an Access 2007 DB through OLE DB, but I noticed that now it is no more supported for Windows Store Apps.

    Many people suggest to use SQLite, but I don't really want to pay to convert my Access DB to SQLite DB.

    It just contains a few hundreds of records and I just have to read it from my app (no edits, no updates)!

    Any solution?

    Friday, January 3, 2014 7:12 PM

Answers

  • there isnt a really good out of the box solution.

    - go sqllite

    - set your access db on a webserver and expose the data through webservices

    - implement access dataaccess yourself (where i dont have a clue where to start, think this going be verrrrrrry hard)


    Microsoft Certified Solutions Developer - Windows Store Apps Using C#

    • Marked as answer by Jasper91 Saturday, January 4, 2014 9:16 AM
    Friday, January 3, 2014 7:20 PM
  • i would start here: http://www.asp.net/web-api/overview/creating-web-apis

    Microsoft Certified Solutions Developer - Windows Store Apps Using C#

    • Marked as answer by Jasper91 Sunday, January 5, 2014 9:46 PM
    Saturday, January 4, 2014 2:32 PM
  • Many people suggest to use SQLite, but I don't really want to pay to convert my Access DB to SQLite DB.

    I'd recommend converting and keeping the db in your app. A web service is better for large data or data which is likely to change.

    There are a number of free converters listed at http://sqlite.org/cvstrac/wiki?p=ConverterTools

    --Rob

    • Marked as answer by Jasper91 Sunday, January 5, 2014 9:46 PM
    Saturday, January 4, 2014 4:11 PM
    Moderator

All replies

  • there isnt a really good out of the box solution.

    - go sqllite

    - set your access db on a webserver and expose the data through webservices

    - implement access dataaccess yourself (where i dont have a clue where to start, think this going be verrrrrrry hard)


    Microsoft Certified Solutions Developer - Windows Store Apps Using C#

    • Marked as answer by Jasper91 Saturday, January 4, 2014 9:16 AM
    Friday, January 3, 2014 7:20 PM
  • I think I'll choose the 2nd! Can you provide me a link to some tutorial or example...

    I just don't know where to start! :S

    Friday, January 3, 2014 7:36 PM
  • i would start here: http://www.asp.net/web-api/overview/creating-web-apis

    Microsoft Certified Solutions Developer - Windows Store Apps Using C#

    • Marked as answer by Jasper91 Sunday, January 5, 2014 9:46 PM
    Saturday, January 4, 2014 2:32 PM
  • Many people suggest to use SQLite, but I don't really want to pay to convert my Access DB to SQLite DB.

    I'd recommend converting and keeping the db in your app. A web service is better for large data or data which is likely to change.

    There are a number of free converters listed at http://sqlite.org/cvstrac/wiki?p=ConverterTools

    --Rob

    • Marked as answer by Jasper91 Sunday, January 5, 2014 9:46 PM
    Saturday, January 4, 2014 4:11 PM
    Moderator
  • Ok, thank you guys!
    Sunday, January 5, 2014 9:46 PM