- Create docker image
docker run --name codingWiki -e MYSQL_ROOT_PASSWORD=P@ssw0rd -p 3306:3306 -d mysql:latest
- after connecting on it create database
CREATE DATABASE CodingWiki;
- Use any mysql client to connect to the DB Server. Recommended: Rider's DB Client
- Rider will ask you for the connection port 3306, username root, password P@ssw0rd
- Create a new Database named
CodingWiki
through the client or run this sql scriptCREATE DATABASE CodingWiki
- Add your table to SherlockMySqlDBContext.cs as a DBSet<>
- Run
dotnet ef migrations add {MyMigrationName}
to add a new diff - To see your changes locally, run
dotnet ef database update