Fetch Data from MS Access using .NET Core

Question

I am actually on my first experience with .NET Core and trying to do a simple console application to fetch data from a MS Access database, and dump it into my MySQL database.

Normally I would have used Oledb and fetch all the data into a datatable, then just write it in MySQL. But with .NetCore, we do not have Oledb! Since .NetCore is quite new, I am not able to find some example on the net, how we can do this process.

I have installed the EntityFrameworkCore nuget, but still not able to manipulate it, nor find any documentation of how to fetch the data.

Has anyone been working with .NETCore and has a sample code of how he is fetching the data?

Are you saying that you can't find anything on learn.microsoft.com/en-us/ef/core to do with fetching data? — Neil
– Neil, Commented Oct 17, 2018 at 10:02

Erik A · Accepted Answer · 2018-10-17 10:11:56Z

2

For .NET core and Microsoft Access, your only choice at this moment (afaik) is to use ODBC to fetch data. There's no first party EF core provider for Access databases, and the only third party one that I know of doesn't support .NET core.

Just use System.Data.ODBC.

See MS Docs for how to use it.

answered Oct 17, 2018 at 10:11

Erik A

32.8k13 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nadeem_MK Over a year ago

Is ODBC supported from Linux?

Erik A Over a year ago

Afaik yes, but the Microsoft Access ODBC driver doesn't work under Linux, thus you have to use a third-party ODBC driver. There are many to be found, both open source and commercial.

Nadeem_MK Over a year ago

Is this Afaik a Nuget available in nuget.org? Cannot find it.

Erik A Over a year ago

I've directed you to the nuget for System.Data.ODBC. ODBC drivers are not nuget packages, they're separate installs.

Collectives™ on Stack Overflow

Fetch Data from MS Access using .NET Core

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related