바뀜

← 이전 편집

Asp.net core mvc

258 바이트 제거됨, 2022년 11월 14일 (월) 02:23

편집 요약 없음

==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>

===~~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> Add-Migration InitialCreate~~

~~====복원====~~

~~PM> Update-Database 20161012160749_AddedOrderToCourse~~

~~====업데이트====~~

~~PM> Update-Database~~

===모델===

==dotnet명령어==

===실행===

$ ~/~~.dotnet~~[[usr]]/bin/dotnet run

==[[Service|서비스 ]] 등록 (for linux)==

참고 사이트: https://docs.microsoft.com/ko-kr/aspnet/core/host-and-deploy/linux-nginx?view=aspnetcore-2.2

===서비스 정의 파일 생성===

$ sudo nano /etc/systemd/system/kestrel-helloapp.service

===서비스 파일 정의===

[Unit]

Description=Example .NET Web API App running on Ubuntu

[Service]

WorkingDirectory=/var/www/helloapp

ExecStart=/usr/bin/dotnet /var/www/helloapp/helloapp.dll

Restart=always

~~<nowiki>~~#~~</nowiki>~~ Restart service after 10 seconds if the dotnet service crashes:

RestartSec=10

KillSignal=SIGINT

SyslogIdentifier=dotnet-example

User=www-data

Environment=ASPNETCORE_ENVIRONMENT=Production

Environment=DOTNET_PRINT_TELEMETRY_MESSAGE=false

[Install]

WantedBy=multi-user.target

</syntaxhighlight><br />

~~WantedBy=multi-user.target~~

[[분류:Asp.net]]

Jhkim

사무관, 관리자

편집

2,431

번

wwiki β

바뀜

Asp.net core mvc

wwiki ^β