I searched...searched , searched again & built it finally

It was last year November 2019, I was working for one of the application architecture and database design for one of the application. It was a simple application and client wants to get it completed as soon as possible. It was agile process of development so we started the development & discussion in parallel. We planned to give first release of application in 3 months of time as it was a small application.

This is the story of first 2 month. From day one we were having our database ready with almost all tables as per our understanding. (we thought so :) ). But client requirement is not about the web app. He wants to perform a lot of admin task in background. We end up adding a lot of supporting tables, which are there in background but application user does not care about it. In those 2 month we built a lot of APIs, changed a lot of endpoints, written a lots of input/output models and interfaces. And everything keeps changing as we keep on adding more features, some time to satisfy client requirement and some time to improve performance.

We end-up building a beautiful UI & a messy REST API back end. Then I started to search for a tool which can help me to build a REST API Automatically with my own way of coding. I searched...searched and tried almost all possible combination of google search keywords to find REST API generator hidden somewhere over internet. But I was not lucky enough. (or I can say, I was lucky not to find anything :P)

After all the hard time wasted, I decided to build something of my own which can automate my development work. And the result was this "MS SQL dotnet Core REST API Generator". It helped me to clean the back end and copy paste the business logic again quickly to close the project within a month time. As the code was generated automatically there was no bug or code review problem.

Recently I have added more features like

Stored Procedure to REST API Generator.
Multiple table result as JSON return from Stored Procedure.
Output parameter handling of Stored Procedure.
Order By multiple column & directions.
Delete with multiple column conditions.
Upload File Endpoint.
Hope my tool may help others to reduce the time and efforts.

Thanks for reading!

https://codecanyon.net/item/ms-sql-to-net-core-rest-api-generator-jwt-auth-swagger-postman/28571454 #RESTPAIGenerator #StoredProcedureToRESTAPIGenerator #MSSQLToRestAPI #MicroServiceGenerator #dotnetcoreapigenerator