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?
 
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
 
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
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.