©EF Core - 관련 링크

Soonyoung Kim·2021년 12월 13일

🆓오늘의 EF-Core

목록 보기

3/6

https://jasonwatmore.com/post/2019/10/11/aspnet-core-3-jwt-authentication-tutorial-with-example-api#authorize-attribute-cs

ASP.NET Core JWT Authentication Project Structure
The tutorial project is organised into the following folders:
Controllers - define the end points / routes for the web api, controllers are the entry point into the web api from client applications via http requests.
Models - represent request and response models for controller methods, request models define the parameters for incoming requests, and response models can be used to define what data is returned.
Services - contain business logic, validation and data access code.
Entities - represent the application data.
Helpers - anything that doesn't fit into the above folders.

EFCore.NamingConventions 누겟 설치를 통해서 Naming Conventions for Entity Framework Core Tables and Columns.
Startup.cs 파일에서 .UseSnakeCaseNamingConvention() 추가하면 snakecase 로 변경 됩니다.

...

public void ConfigureServices(IServiceCollection services)
{

    services.AddControllers();
    var connection = Configuration.GetConnectionString("DaqDatabase");
            services.AddDbContext<ApplicationDbContext>(options => ptions.UseNpgsql(connection).UseSnakeCaseNamingConvention());
    ...
}
...

변경 확인

create table "Users"
(
    id                   text    not null
        constraint pk_users
            primary key,
    user_name            varchar(256),
    normalized_user_name varchar(256),
    email                varchar(256),
    normalized_email     varchar(256),
    password_hash        text,
    email_confirmed      boolean not null
);

What is AspNetRoleClaims?

https://quick-adviser.com/what-is-aspnetroleclaims/

JWT Role setting

https://www.thereformedprogrammer.net/a-better-way-to-handle-authorization-in-asp-net-core/#setting-the-scene-a-look-at-different-application-security-needs

정말 좋은 글이나, 지금 이해하기 조금 어려웠다.. 다시 확인해봐야함

https://ichi.pro/ko/asp-net-core-3-bearer-mich-jwtleul-sayonghan-gwonhan-buyeo-mich-injeung-53059027503901

https://codewithmukesh.com/blog/aspnet-core-api-with-jwt-authentication/

endpoint 연결하기

https://codewithmukesh.com/blog/entity-framework-core-in-aspnet-core/
https://codewithmukesh.com/blog/aspnet-core-api-with-jwt-authentication/
https://codewithmukesh.com/blog/refresh-tokens-in-aspnet-core/

https://www.c-sharpcorner.com/article/handle-refresh-token-using-asp-net-core-2-0-and-json-web-token/

https://galdin.dev/blog/getting-started-with-identity-in-asp-net-core/https://www.youtube.com/watch?v=fOQjWUokhn8

https://code-maze.com/using-refresh-tokens-in-asp-net-core-authentication/

https://www.scottbrady91.com/aspnet-identity/implementing-mediums-passwordless-authentication-using-aspnet-core-identity

http://docs.identityserver.io/en/latest/topics/signin_external_providers.html

https://codewithmukesh.com/blog/pagination-in-aspnet-core-webapi/

로그 남기기

https://code-maze.com/structured-logging-in-asp-net-core-with-serilog/
https://github.com/CodeMazeBlog/logging-aspnetcore-serilog
https://docs.datadoghq.com/logs/log_collection/csharp/?tab=serilog
https://andrewlock.net/5-ways-to-set-the-urls-for-an-aspnetcore-app/

ASP 굿 좋은 자료

https://www.yogihosting.com/aspnet-core-model-validation/
https://www.tutorialsteacher.com/core/how-to-change-the-name-of-the-default-file-to-be-served-on-root-request
https://code-maze.com/structured-logging-in-asp-net-core-with-serilog/
http://www.egocube.pe.kr/translation/content/asp-net-core-mvc-tutorial-1/201605280001

efcore OAuth

https://blog.danggun.net/7600
https://docs.microsoft.com/ko-kr/dotnet/architecture/microservices/secure-net-microservices-web-applications/
https://docs.microsoft.com/ko-kr/aspnet/core/fundamentals/middleware/?view=aspnetcore-6.0
https://thatisgood.tistory.com/entry/OAuth20-OAuth20-%EC%9D%B4%EB%A1%A0-%EC%A0%95%EB%A6%AC-01
https://www.digitalocean.com/community/tutorials/an-introduction-to-oauth-2
https://chsakell.com/2019/03/11/asp-net-core-identity-series-oauth-2-0-openid-connect-identityserver/
https://velog.io/@jakeseo_me/Oauth-2.0%EA%B3%BC-OpenID-Connect-%ED%94%84%EB%A1%9C%ED%86%A0%EC%BD%9C-%EC%A0%95%EB%A6%AC
https://6991httam.medium.com/oauth%EB%9E%80-%EA%B7%B8%EB%A6%AC%EA%B3%A0-openid-8c46a65616e6
http://docs.identityserver.io/en/latest/topics/startup.html
https://dev.to/robinvanderknaap/setting-up-an-authorization-server-with-openiddict-part-vi-refresh-tokens-5669
https://co-de.tistory.com/29
https://d2.naver.com/helloworld/24942 - 정리❤
http://www.2e.co.kr/news/articleView.html?idxno=208594 - ❤
https://jins-dev.tistory.com/entry/Open-ID-%EC%99%80-OAuth-%EC%9D%B8%EC%A6%9D%EC%97%90-%EB%8C%80%ED%95%98%EC%97%AC
https://carbosteelwiremesh.com/ko/ko92401/

https://www.c-sharpcorner.com/article/cookie-authentication-in-asp-net-core/ - 간단예제

굿(spring)
https://alexbilbie.com/guide-to-oauth-2-grants/
https://medium.com/@archnaaju/oauth2-and-spring-boot-2-a-complete-guide-to-setup-a-separate-authorization-server-resource-4d760cc0b1e1

내가 찾던 내용인듯하다
https://procodeguide.com/programming/oauth2-and-openid-connect-in-aspnet-core/

정리 굿
https://velog.io/@rohkorea86/oAuth-oAuth%EB%A5%BC-%EC%9D%B4%ED%95%B4%ED%95%98%EB%8A%94-%EC%9A%A9%EC%96%B4%EC%A0%95%EB%A6%AC

in-memory/ database
https://docs.duendesoftware.com/identityserver/v6/overview/big_picture/

성공!
코드 : https://github.com/vince-nyanga/IdentityServerTutorial
내용 : https://honesdev.com/identity-server-part-1/

dotnet ef migrations add InitialIdentityServerPersistedGrantDbMigration -c PersistedGrantDbContext -o Data/Migrations/IdentityServer/PersistedGrantDb --project Server
dotnet ef migrations add InitialIdentityServerConfigurationDbMigration -c ConfigurationDbContext -o Data/Migrations/IdentityServer/ConfigurationDb --project Server
dotnet ef migrations add InitialAppDbContextDbMigration -c AppDbContext -o Data/Migrations/AppContext --project Server
dotnet ef database update -c PersistedGrantDbContext --project Server
dotnet ef database update -c ConfigurationDbContext --project Server
dotnet ef database update -c AppDbContext --project Server

https://feras.blog/how-to-use-asp-net-identity-and-identityserver4-in-your-solution/
https://www.netiq.com/documentation/access-manager-45-appliance/admin/data/b1dj6b2f.html

https://pomo0703.tistory.com/208

https://bigexecution.tistory.com/95

https://jasonwatmore.com/post/2022/01/07/net-6-user-registration-and-login-tutorial-with-example-api