Welcome to my Web Application!

This project was built as part of my postgraduate course in Big Data Analytics at Georgian College. It combines concepts taught in the following .NET tutorials:

• Create an ASP.NET Core web app with user data protected by authorization
• Deploy an ASP.NET Core and Azure SQL Database app to Azure App Service

Demo Video

Take a look at the web application's demo video:

How to Use It

The web application interacts with an Azure SQL Database to perform CRUD (Create, Read, Update, Delete) operations on data.

Access to the database is regulated via a role-based authorization. Here's how the authorization and authentication mechanisms might work for each level:

• User: Users can view existing data stored in the database, submit new data and delete their own data.
• Manager: In addition to the access level granted to users, managers can approve or reject existing data via the details page of each entry.
• Admin: In addition to the access level granted to managers, admins can edit and delete any entry in the database.

New accounts with user access level can be created on the 'Register' page. To perform operations requiring admin or manager access level, use the following accounts:

• manager@contoso.com:Passw0rd!
• admin@contoso.com:Passw0rd!

Technologies Used

• ASP.NET Core: Used for building the web application.
• C#: Programming language for backend development.
• Azure Web App: Hosting platform for deploying the application.
• Azure SQL Database: Cloud-based database solution for storing data.
• GitHub: Version control system for collaboration and code management.
• GitHub Actions: Automated workflows for continuous integration and deployment.

Skills Acquired

Through this project, I gained valuable skills in:

• Deploying applications on Azure infrastructure.
• Managing and querying data in Azure SQL Database.
• Version control and collaboration using Git/GitHub.
• Automating deployment processes with GitHub Actions.
• Troubleshooting compatibility issues between local development and Azure Web App deployments.

GitHub Repository

Check out the code for this application following this link:https://github.com/brandaovh/aspnet-core-auth-sqldb.

Contact Information

Feel free to reach out to me if you have any questions or would like to connect:

Email: brandaovh@gmail.com
LinkedIn: linkedin.com/in/brandaovh/