I have completed both Dotnet and SQL Assesment and show all my step in this github repository
You can find all my complete step in these markdown files:
| Task | Time |
|---|---|
| Understanding the API via Swagger/Postman | < 1 hour |
| Project setup and package installation | < 30 minutes |
| Writing all model and service files | ~ 4 hours |
| Debugging migration and DB errors | ~ 1 hour |
| Testing endpoints and upsert logic | ~ 30 minutes |
| Git setup and push to GitHub | ~ 10 minutes |
| SQL Assesment | 1 hour |
| Documentation | 2 hour |
| Total | **~ 10 hours** |