How to add local database file to Visual Studio Mac 2017

Question

I'm creating a hotel management service in C# on Visual Studio (Mac) and I can't seem to find a good explanation on how to add a local database file to my project. I created my database table in open office (.odb file) but there doesn't seem to be a way for me to implement this in my project. The documentation has nothing on this either. Any one got a clue how to add databases to a Mac Visual studio project?

Answer 1

there are no localDB in visual studio for mac, you need to install the docker image for sql server.

here is the link

Answer 2

You can run SQL Server on a Mac now:

https://database.guide/how-to-install-sql-server-on-a-mac/

Using Docker it can be made as your localhost SQL Server. I've done this and it works. SQL Management studio for Mac is useful too.

Hope this helps someone.