Fiona Sanggang fsanggang

## golb_0_startup.bash
dotnet new blazorserver --use-local-db --auth Individual --name Golb

## golb_2a_sql_server_start.bash
docker pull mcr.microsoft.com/mssql/server:2019-latest
docker run -d - name sql_server -e ACCEPT_EULA=Y -e SA_PASSWORD=<yourPasswordHere> -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest

## golb_2b_sql_server_start.bash
docker ps
CONTAINER ID        IMAGE                                        COMMAND                  CREATED             STATUS              PORTS                    NAMES
831295b80b53        mcr.microsoft.com/mssql/server:2019-latest   "/opt/mssql/bin/perm…"   3 minutes ago       Up 2 seconds        0.0.0.0:1433->1433/tcp   sql_server

## golb_3_appsettings.json
// appsettings.json
{
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=localhost,1433;User ID=sa;Password=superSecurePwd123;Connect Timeout=30;Database=GolbDatabase"
  }
  ... etc
}

## golb_4_startup.cs
// Startup.cs

 // Should not user Database.Migrate() in production, instead migrations should be done as part of deployment
using (var srvc = app.ApplicationServices.GetRequiredService<IServiceScopeFactory>().CreateScope())
    {
        var context = srvc.ServiceProvider.GetService<ApplicationDbContext>();
        context.Database.Migrate();
    }

## golb_5a_install_dotnet_tools.bash
dotnet tool install --global dotnet-ef

## golb_6_post.cs
// Data/Post.cs

using System;

namespace Golb.Data
{
    public class Post
    {
        public int Id { get; set; }
        public string Title { get; set; }

## golb_6_dbcontext.cs
// Data/ApplicationDbContext.cs

public class ApplicationDbContext : IdentityDbContext
{
    ...etc

    public DbSet<Post> Posts { get; set; }

    protected override void OnModelCreating(ModelBuilder builder)
    {

## golb_8_connect_sql_server.bash
docker exec -it sql_server bash

## golb_9_sqlcmd.bash
/opt/mssql-tools/bin/sqlcmd -S localhost -U "sa" -P "yourPasswordHere" -I
	docker pull mcr.microsoft.com/mssql/server:2019-latest
	docker run -d - name sql_server -e ACCEPT_EULA=Y -e SA_PASSWORD=<yourPasswordHere> -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest
	docker ps
	CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
	831295b80b53 mcr.microsoft.com/mssql/server:2019-latest "/opt/mssql/bin/perm…" 3 minutes ago Up 2 seconds 0.0.0.0:1433->1433/tcp sql_server
	// appsettings.json
	{
	"ConnectionStrings": {
	"DefaultConnection": "Data Source=localhost,1433;User ID=sa;Password=superSecurePwd123;Connect Timeout=30;Database=GolbDatabase"
	}
	... etc
	}
	// Startup.cs

	// Should not user Database.Migrate() in production, instead migrations should be done as part of deployment
	using (var srvc = app.ApplicationServices.GetRequiredService<IServiceScopeFactory>().CreateScope())
	{
	var context = srvc.ServiceProvider.GetService<ApplicationDbContext>();
	context.Database.Migrate();
	}
	// Data/Post.cs

	using System;

	namespace Golb.Data
	{
	public class Post
	{
	public int Id { get; set; }
	public string Title { get; set; }
	// Data/ApplicationDbContext.cs

	public class ApplicationDbContext : IdentityDbContext
	{
	...etc

	public DbSet<Post> Posts { get; set; }

	protected override void OnModelCreating(ModelBuilder builder)
	{