ASP.net MVC dev on Mac : Database Connection

This is a post for tips on developing Asp.net on Mac. First, I’ll briefly introduce how to connect to database.

First, Run MS SQL server on Docker. (a setting of MS SQL on Docker will be posted soon) Then, you can find a setting for connection of Database server on Azure data studio.

-> here, you can check server address Defnitely, user must be a sysadmin.

-> Run Visual Studio → appsettings.json →

"ConnectionStrings": {
    "MovieConnectionString": "Server=tcp:ServerAddress,Port;Database=Movie;User Id=ID;Password=Password;Integrated security=False;MultipleActiveResultSets=true;TrustServerCertificate=true"
  }

-> program.cs

  var connstr = builder.Configuration.GetConnectionString("MovieConnectionString");
  builder.Services.AddDbContext<MovieDbContext>(option => option.UseSqlServer(connstr));

-> Make DBContext.

-> Run Visual Studio → Extensions → NugetPackage Management

-> View → Other Windows → Nuget Package Manager Console

-> Add-Migration Initial (Initial is a name to designate the commit)

-> Update-DataBase