I'm trying to set up a local database on my Mac using VS Code for development purposes. I have installed MariaDB via homebrew, and I can access it through the terminal and play around with it.
But how do I get the connection-string to put in to VS Code, so when I'm using Entity Framework Core, it will automatically create the tables in the MariaDB database?
Check the DB provider in : https://docs.microsoft.com/en-us/ef/core/providers/?tabs=dotnet-core-cli
It mention the MariaDB connector as the same as MySQL, using Pomelo.EntityFrameworkCore.MySql, available in Nuget
you can start a project and then add :
dotnet add package Pomelo.EntityFrameworkCore.MySql
Like described in this pretty straight forward tutorial :