Project management application using Angular for user-friendly task tracking and C# .NET MVC with SQL Server for backend data management on AWS, enabling efficient project assignment, progress tracking, and team collaboration.
Process:
- ASP.NET MVC
- Create Models(User, Project, ProjectTask, Milestone) with data annotations.
- Create DTOs to transfer only the required data between the client and server. Also to avoid exposing the navigation properties that cause cycles.
- Add Required NuGet Packages
Microsoft.EntityFrameworkCoreMicrosoft.EntityFrameworkCore.SqlServerMicrosoft.EntityFrameworkCore.Tools
- Create DBContext to interact with the database. This serves as a bridge between the application and the database using Entity Framework Core.
- Create Repositories with async methods to implement data access logic using Entity Framework and interact with the database.
- Create Controllers for basic CRUD (Create, Read, Update, Delete) operations.
- Configure Database Connection. Set up the connections tring to AWS SQL Server. IN PROGRESS