Aashish Panthi Thanks for sharing the code. Good job on getting it to deploy as well. If you dont mind me asking, did you consider using [minimal APIs] (https://medium.com/geekculture/minimal-apis-in-net-6-a-complete-guide-beginners-advanced-fd64f4da07f5)instead of full blown MVC API? Also, you had mentioned "if there was something which could resolve the bug before I tested it", well don't have anything to resolve but surely Unit Tests would have helped a bit. Also the code is light on validations and all. Also consider logging. The database connection looks standard implementation so was curious to know your pain areas? What did you dislike the most developing APIs in C#. The initial ceremony? the tooling?

Would really like to see the api setup. Curious to know what made you say API in C# sucks? Do you have the api code anywhere to look at? You also mentioned database connection is a nightmare. Which database were you connecting to and also what's your dev env OS? C# used to be a nightmare outside MS ecosystem but in last 6 7 yeare21s it has improved leaps and bound. So just curious to know.