Skip to content

Microservices communication developed with .Net Core and database connection with Dapper and SQL Server.

Notifications You must be signed in to change notification settings

marcoaurelyo/Microservices-NetCore-Dapper-SQLServer

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Microservices-NetCore-Dapper-SQLServer

Microservices communication with JWT authorization developed with .Net Core and database connection with Dapper and SQL Server.

Technologies:

  • .Net Core 2.2
  • JWT Authorization
  • Dapper
  • SQL Server
  • Swagger
  • FluentValidation
  • AutoMapper

To run this project

  • Run the script located at "/Docs/script.sql" to create a SQL Server database.

  • In this project, the connection string is set in the APITestRegister's appsettings.json as it follows: Server=localhost;Database=TestDB;Trusted_Connection=True;

  • Set the Issuer, Audience and Secret of your JWT inside the appsettings.json of both solutions:

appsettings.json

  • The APITestRegister's URL must be informed in the APITestGateway's appsettings.json:

routes

  • APITestGateway's swagger:

swagger-0

  • APITestRegister's swagger:

swagger-3

  • An authorization token must be created in the APITestGateway's method "/api/Gateway/Token".

swagger-1

  • The parameter "route" informed in the APITestGateway's method "/api/Gateway/{route}" must have the pattern "Controller_Method". For example: the route "user_login" will allow the APITestGateway to access the APITestRegister's method "/api/User/Login".
  • The parameters sent in the request must be the same as the ones the APITestRegister's methods expect to receive.

swagger-2

About

Microservices communication developed with .Net Core and database connection with Dapper and SQL Server.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C# 100.0%