macOS ではじめる ASP.NET Core x Entity Framework Core x PostgreSQL ref: https://qiita.com/kasecato/items/134256c4954aa6115502

Director.cs

using System;

namespace StarWars.Model
{
    public class Director
    {
        public int DirectorId { get; set; }
        public int Episode    { get; set; }
        public string Name    { get; set; }
        public DateTime Born  { get; set; } // 追加
    }
}

docker-compose.yml

version: '3'
services:
  db:
    build: ./postgres
    container_name: postgres-starwars
    environment:
      POSTGRES_USER: c3po
      POSTGRES_PASSWORD: r2d2
      POSTGRES_DB: starwars
    ports:
      - 5432:5432

Dockerfile

FROM postgres:11

file0.txt

$ brew cask install dotnet-sdk

file1.txt

StarWars
├── project.csproj
├── docker-compose.yml
├── src
│   ├── Domain
│   │   └── StarWarsContext.cs
│   ├── Model
│   │   └── Director.cs
│   └── Program.cs
└── test
    └── StarWarsTest.cs

file10.txt

$ dotnet tool update --global dotnet-ef --version 3.1.6

file11.txt

$ dotnet ef migrations add StarWarsEp7

file12.txt

$ dotnet ef database update

file13.txt

$ docker exec -it postgres-starwars bash
# psql -U c3po -d starwars
# \d "Directors"
                                   Table "public.Directors"
   Column   |  Type   | Collation | Nullable |                     Default
------------+---------+-----------+----------+-------------------------------------------------
 DirectorId | integer |           | not null | nextval('"Directors_DirectorId_seq"'::regclass)
 Episode    | integer |           | not null |
 Name       | text    |           |          |
Indexes:
    "PK_Directors" PRIMARY KEY, btree ("DirectorId")

# \quit
# exit

file14.txt

$ dotnet ef migrations add StarWarsEp7.2
$ dotnet ef database update

file15.txt

$ dotnet ef migrations add StarWarsEp7.2
$ dotnet ef database update

file16.txt

$ docker exec -it postgres-starwars bash
# psql -U c3po -d starwars
# \d "Directors"
                                               Table "public.Directors"
   Column   |            Type             | Collation | Nullable |                      Default
------------+-----------------------------+-----------+----------+----------------------------------------------------
 DirectorId | integer                     |           | not null | nextval('"Directors_DirectorId_seq"'::regclass)
 Episode    | integer                     |           | not null |
 Name       | text                        |           |          |
 Born       | timestamp without time zone |           | not null | '0001-01-01 00:00:00'::timestamp without time zone
Indexes:
    "PK_Directors" PRIMARY KEY, btree ("DirectorId")

# \quit
# exit

file17.txt

$ dotnet test

file18.txt

$ dotnet test

file19.txt

$ dotnet test
Test run for /Users/kasecato/GitHub/kasecato/osxcsharp/bin/Debug/netcoreapp3.1/StarWars.dll(.NETCoreApp,Version=v3.1)
Microsoft (R) Test Execution Command Line Tool Version 16.6.0
Copyright (c) Microsoft Corporation.  All rights reserved.

Starting test execution, please wait...

A total of 1 test files matched the specified pattern.

Test Run Successful.
Total tests: 1
     Passed: 1
 Total time: 2.2642 Seconds

file2.txt

$ dotnet restore

file20.txt

$ docker exec -it postgres-starwars bash
# psql -U c3po -d starwars
# select * from "Directors";
 DirectorId | Episode |     Name     |        Born
------------+---------+--------------+---------------------
          4 |       7 | J. J. Abrams | 1966-06-27 00:00:00
# \quit
# exit

file21.txt

$ sudo nuget update -self
$ nuget locals all -clear
$ sudo rm -rf /usr/local/share/dotnet/
# 最新の .NET Core 1.1 SDK をインストールする

file22.txt

$ dotnet migrate

file3.txt

$ dotnet restore

file4.txt

dnvm upgrade -r mono

file5.txt

dotnet ef migrations add StarWarsEp7

file6.txt

$ docker-compose up

file7.txt

$ docker-compose up

file8.txt

$ docker-compose up

file9.txt

$ dotnet tool install --global dotnet-ef --version 3.1.6

Program.cs

using System;
namespace StarWars
{
    public class Program
    {
        public static void Main(string[] args)
        {
            Console.WriteLine("Hello World!");
        }
    }
}

project.csproj

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <AssemblyName>StarWars</AssemblyName>
    <PackageId>StarWars</PackageId>
    <VersionPrefix>1.0.0</VersionPrefix>
    <TargetFramework>netcoreapp3.1</TargetFramework>
    <OutputType>Library</OutputType>
    <DebugType>portable</DebugType>
    <GenerateDocumentationFile>false</GenerateDocumentationFile>
    <GenerateRuntimeConfigurationFiles>true</GenerateRuntimeConfigurationFiles>
    <RuntimeFrameworkVersion>3.1.6</RuntimeFrameworkVersion>
  </PropertyGroup>

  <ItemGroup>
    <!-- xUnit.net -->
    <!-- https://xunit.github.io/docs/getting-started/netcore/cmdline -->
    <PackageReference Include="Microsoft.NET.Test.Sdk" Version="16.6.1" />
    <PackageReference Include="xunit" Version="2.4.1" />
    <PackageReference Include="xunit.runner.visualstudio" Version="2.4.2" />

    <!-- Npgsql Entity Framework Core -->
    <!-- http://www.npgsql.org/efcore/index.html -->
    <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="3.1.4" />

    <!-- The dotnet ef commands are included in the .NET Core SDK, but to enable the commands you have to install the Microsoft.EntityFrameworkCore.Design package. -->
    <!-- https://docs.microsoft.com/en-us/ef/core/miscellaneous/cli/dotnet#ef-core-3x -->
    <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="3.1.6" />
  </ItemGroup>

</Project>

project.json

  "buildOptions": {
    "emitEntryPoint": true

StarWarsContext.cs

using Microsoft.EntityFrameworkCore;
using StarWars.Model;

namespace StarWars.Domain
{
    public class StarWarsContext : DbContext
    {
        public DbSet<Director> Directors { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
            => optionsBuilder.UseNpgsql("Host=localhost;Database=starwars;Port=15432;Username=c3po;Password=r2d2");
    }
}

StarWarsCrudTest.cs

using System;
using StarWars.Domain;
using StarWars.Model;
using Xunit;

namespace StarWars.Test
{
    public class StarWarsCrudTest
    {
        [Fact]
        public void CreateTest()
        {
            using (var db = new StarWarsContext())
            {
                // arrange
                var dirEp7 = new Director()
                {
                    DirectorId = 4,
                    Episode = 7,
                    Name = "J. J. Abrams",
                    Born = DateTime.Parse("June 27, 1966")
                };

                // act
                // SELECT
                var dirEp7Db = db.Directors.Find(dirEp7.DirectorId);

                // DELETE
                if (dirEp7Db != null)
                {
                db.Directors.Remove(dirEp7Db);
                db.SaveChanges();
                }

                // INSERT
                db.Directors.Add(dirEp7);
                var countIns = db.SaveChanges();

                // SELECT
                dirEp7Db = db.Directors.Find(dirEp7.DirectorId);

                // assert
                Assert.Equal(1, countIns);
                Assert.Equal("J. J. Abrams", dirEp7Db.Name);
            }
        }
    }
}