How to add local database file to Visual Studio Mac 2017

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

here is the link

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.