ASP.NET Core access a MDB Access database.

Hi,

Can an ASP.NET Core app support reading and writing to an access database? BTW this would be a ASP.Core app running on a Linux host.

https://blogs.msdn.microsoft.com/dotnet/2016/11/09/net-core-data-access/

I assume it cant but wanted to double check in case there is another way.

Thanks,

Ward
LVL 1
whorsfallAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David Johnson, CD, MVPOwnerCommented:
You got that right. Unless you can get a linux flavour of a .dll to access the access.mdb

From your referenced url
What about OLE DB?
OLE DB has been a great way to access various data sources in a uniform manner, but it was based on COM, which is a Windows-only technology, and as such was not the best fit for a cross-platform technology such as .NET Core. It is also unsupported in SQL Server versions 2014 and later. For those reasons, OLE DB won’t be supported by .NET Core.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dirk StraussSenior Full Stack DeveloperCommented:
Out of interest, SQL Server is now supported on Linux: Microsoft Releases SQL Server 2017 Database on Linux Systems.
Then, just for the heck of it, check out this thread: how to use an MS-Access file from Linux?.
0
Pushpakumara MahagamageVPCommented:
Why don't you use opensource database like MySQL community edition. You may use access database creating many security holes. you can use SQL Server express edition for small application. SQL Express edition is free. My opinion is migrate your data to Mysql or MS SQL.
0
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

whorsfallAuthor Commented:
Hi,

I was asking because an app I am thinking of coverting to asp.core .net - old site is  uses access database.

So this could allow old and new system interpolate with old database until new one is completely done.

However you do raise some good points though. Security might mean a rethink as well.

Thanks,

Ward
0
Dirk StraussSenior Full Stack DeveloperCommented:
Hi Ward

Part of taking over a legacy app and converting it, should be to improve on old technology (which is what you are doing by going the .NET Core route). As other experts have suggested, try to migrate away from an Access database. Have a look at the following articles that might aid you in the migration:

Migrating Access databases to SQL Server - Azure SQL DB (AccessToSQL)

SQL Server Migration Assistant for Access (AccessToSQL)

Getting started with SQL Server Migration Assistant for Access (AccessToSQL)

Converting an Access Database to SQL Server - How to Use the Upsizing Wizard to Convert Your Database

Good luck!
0
David Johnson, CD, MVPOwnerCommented:
enough information to confirm an answer
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.