Asp.net core mvc

MySQL에서 마이그레이션 히스토리 테이블 생성

에러메시지

EFMigrationsHistory' doesn't exist

쿼리문

CREATE TABLE IF NOT EXISTS __EFMigrationsHistory (

MigrationId varchar(150) NOT NULL,

ProductVersion varchar(32) NOT NULL,

CONSTRAINT PK___EFMigrationsHistory PRIMARY KEY (MigrationId)

);

MySQL Identity 적용

에러메시지

InvalidOperationException: No coercion operator is defined between types 'System.Int16' and 'System.Boolean'.

PostgreSQL

nuget package

Install-Package Npgsql.EntityFrameworkCore.PostgreSQL

connection string

"User ID=damienbod;Password=1234;Host=localhost;Port=5432;Database=damienbod;Pooling=true;"

마이그레이션 명령

복원

PM> Update-Database 20161012160749_AddedOrderToCourse