connect and read .MDB item with C# in UWP

2019-09-06 06:55发布

问题:

I'm developing a UWP application and want to read a MDB file to convert this database to a SQLite database.

I read that i could use OleDbConnection to open MS Access database following this topic : connect and read .MDB item with C#

But OleDbConnection is not available in UWP project. It seems not available in System.data

Do you know solution to read MDB file in a UWP application programatically?

EDIT :

Microsoft team answered me this information :

Currently, there are no in-box API, or tools compliant third UWP out-of-the-box that allows you to do that.

There is nothing in the roadmap for the moment regarding this point!

I propose you two tracks to explore:

  • Convert your .mdb file into sqlite "Ready to use".
  • Develop Web API that exposes the data of your mdb.

回答1:

There's nothing in-box to do this. I'm not aware of any 3rd party libraries that understand .MDBs and supports UWP apps.

I'd convert the .MDB to SQLite from a non-UWP app and then have the UWP app deal only with SQLite.

It looks like there are many existing tools to do the conversion