We have created a table UserInfo and then 4 stored procedure for CRUD The web api has been hosted on Azure portal and having following URL
This web api has been integrated with Swagger interface for API testing and documentation
We have put validations using Fluent validations.
For Selecting / Listing stored procedure we need to pass ValidationMode = 'ByPass' to retrieve the records.
We have extentensively used Dependency Injection, IoC in the solutiion The solution has been designed using DRY concepts with Domain Driven design.
TBD : We can add token based Authentication, API Key implementation JWT and all.
Datbase : SQL Backend : Dot Net Core 5.0 Hosting : Azure Portal