ASP.NET Core access a MDB Access database.

whorsfall
whorsfall used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
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.
Dirk StraussSenior Full Stack Developer
Distinguished Expert 2017
Commented:
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?.
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.
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Author

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
Dirk StraussSenior Full Stack Developer
Distinguished Expert 2017
Commented:
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!
Top Expert 2016

Commented:
enough information to confirm an answer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial