편집
2,431
번
바뀜
편집 요약 없음
==MySQL=====MySQL에서 마이그레이션 히스토리 테이블 생성===다음 에러메시지가 출력되는 경우에 EFMigrationsHistory' doesn't exist다음 쿼리문을 사용하여 테이블을 생성한다.<syntaxhighlight lang="sql">CREATE TABLE IF NOT EXISTS __EFMigrationsHistory ( MigrationId varchar(150) NOT NULL, ProductVersion varchar(32) NOT NULL, CONSTRAINT PK___EFMigrationsHistory PRIMARY KEY (MigrationId));</syntaxhighlight> ===Identity 적용===
====에러메시지====
===모델=쿼리문====CREATE TABLE IF NOT EXISTS __EFMigrationsHistory (
==[[Service|서비스]] 등록 (for linux);==참고 사이트: https://docs.microsoft.com/ko-kr/aspnet/core/host-and-deploy/linux-nginx?view=aspnetcore-2.2
===MySQL Identity 적용서비스 정의 파일 생성=== $ sudo nano /etc/systemd/system/kestrel-helloapp.service
===서비스 파일 정의=에러메시지==<syntaxhighlight lang="ini">[Unit]Description=InvalidOperationException: No coercion operator is defined between types 'System.Int16' and 'System.Boolean'Example .NET Web API App running on Ubuntu
[Service]WorkingDirectory=/var/www/helloappExecStart=/usr/bin/dotnet /var/www/helloapp/helloapp.dllRestart= PostgreSQL always# Restart service after 10 seconds if the dotnet service crashes:RestartSec=10KillSignal=SIGINTSyslogIdentifier=dotnet-exampleUser=www-dataEnvironment=ASPNETCORE_ENVIRONMENT=ProductionEnvironment=DOTNET_PRINT_TELEMETRY_MESSAGE=false
[Install]WantedBy==== nuget package ====Installmulti-Package Npgsqluser.EntityFrameworkCore.PostgreSQL target</syntaxhighlight><br />