ASP.NET Core and Entity Framework Online Course

ASP.NET Core and Entity Framework Online Course

Master ASP.NET Core and Entity Framework to build modern, dynamic web applications. This course starts with the fundamentals of .NET, MVC architecture, and environment setup, then guides you through GitHub integration, database configuration with Entity Framework, service layer development, and user authentication. With hands-on projects, you’ll gain practical experience in creating full-fledged applications. Advanced modules cover deployment to IIS and Microsoft Azure, as well as optimization strategies for different environments. By the end, you’ll be equipped with the skills to design, develop, and deploy robust ASP.NET Core applications ready for real-world use.

Who should take this Course?

The ASP.NET Core and Entity Framework Online Course is designed for web developers, software engineers, and programmers who want to build modern, scalable, and data-driven applications using Microsoft’s latest technologies. It is equally valuable for students, IT professionals, and aspiring full-stack developers looking to strengthen their backend development skills, integrate databases seamlessly, and gain hands-on experience with ASP.NET Core and Entity Framework.

What you will learn

• Integrate and manage GitHub for source control in ASP.NET Core projects.
• Implement authentication and authorization features using ASP.NET Core Identity.
• Deploy web applications to IIS and Microsoft Azure.
• Apply best practices in coding, testing, and deployment.
• Utilize dependency injection for improved code modularity and maintainability.
• Refactor and structure applications using advanced architectural patterns.

Course Outline

Introduction

• Introduction

Getting Started with ASP.NET Core

• What is .NET?
• What is ASP.NET Core?
• What Will You Learn in this Course?
• What We Are Building

Environment Configuration

• Section Overview
• Install Visual Studio (Windows Only)
• Tour Visual Studio
• Install Visual Studio Code and .NET SDK (Any OS)
• Visual Studio Code Tour
• Section Review

Project Setup and Configurations

• Section Overview
• Create ASP.NET Core Web Application Project (Visual Studio)
• Create ASP.NET Core Web Application Project (Visual Studio Code)
• Understanding the MVC Pattern
• What Are Views?
• Testing with Visual Studio and Visual Studio Code
• What are Controllers?
• Explore Controllers
• What are Models?
• Explore Models
• Important Files and Concepts
• Review Application Logs and Launch Settings
• Activity: Create New View, Model and Controller
• Good Practices and Recommendations
• Section Review

Introducing Source Control Management (GitHub)

• Section Overview
• What is Source Control Management?
• Introducing Git and GitHub
• Setup a GitHub Account
• Add Project to Source Control (Visual Studio)
• Add Project to Source Control (Visual Studio Code)
• Understanding Git Operations (Commits, Push, and Pull)
• Section Review

Modifying the Website Layout

• Section Overview
• Understanding the Layout File
• Exploring Static Files and Assets
• Exploring the Bootstrap Framework
• Modifying the Layout File
• Review and Add Changes to GitHub
• Section Review

Database Setup (Entity Framework, Tables, and Migrations and Data Seeding)

• Section Overview
• What is Entity Framework Core?
• Review EF Core in Project (Visual Studio and Visual Studio Code)
• Review Database Context Class
• Understanding Connection Strings
• What are Migrations?
• Adding a Migration
• Create Database from Migration
• Resource: Setup Microsoft SQL Server with Docker
• Best Practices and Recommendations
• Section Review

Leave Type Management Module

• Section Overview
• Module Overview and Requirements
• Create Leave Type Table (Model, Migration, and Database Update)
• Explore Scaffolding and Functionality
• Review Scaffolded Index View and Action
• Understanding Dependency Injection
• Understanding Asynchronous Programming
• Review Scaffolded Create View and Action
• Understanding Form Bindings and Controls
• Review Scaffolded Details View and Action
• Review Scaffolded Edit View and Action
• Review Scaffolded Delete View and Action
• Activity: Complete Full End to End CRUD Testing
• Activity: Beautify Module Pages
• Review and Add Changes to GitHub
• Section Review

Using View Models and Mappers

• Section Overview
• What are View Models?
• Refactor Index with View Model
• Why Use a Mapper?
• Setup and Use AutoMapper
• Refactor Details with View Model
• Understanding Validation
• Refactor Create with View Model
• Adding Validation Rules
• Refactor Edit with View Model
• Activity: Setup Base Class and Change Labels
• Activity: Validate If Name Already Exists in Database
• Section Review

Implementing a Service Layer

• Section Overview
• What is a Service Layer?
• Service Layer vs Repository and Unit of Work Patterns
• Adding the Service Layer (Implementation)
• Adding the Service Layer (Contract and Implementation)
• Understanding Dependency Injection Methods
• Refactor Controller to Use Service
• Activity: Test Refactored Application
• Review and Add Changes to GitHub
• Section Review

User Authentication and Authorization

• Section Overview
• Module Overview and Requirements
• Understanding Authentication and Authorization
• Understanding ASP.NET Core Identity Features
• Activity: Testing Registration and Login
• Seeding Default Data
• Scaffolding Identity Pages
• What are Razor Pages?
• Activity: Review Login Razor Page
• Customize User Record and Update Database
• Customize Registration Process
• Assign Roles to Users at Registration
• Bug Fix: Null Exception from Invalid Registration
• Implement Email Service
• Restrict Features Based on User
• Review and Add Changes to GitHub
• Section Review

Leave Allocation Module

• Section Overview
• Module Overview and Requirements
• Database Relationships Overview
• Entity Framework Core and Relationships
• Create Leave Allocation Module Data Models
• Create Migration and Update Database
• Add Period Management Module
• Setup Leave Allocation Service
• Setup Employee Allocation Logic
• Setup Employee Allocation at Registration
• Setup Leave Get Allocation Logic
• Setup Leave Allocation Controller
• Implement Employee Leave Allocation Queries
• Setup Employee Leave Allocation View
• Activity: Test and Refactor Employee Allocations
• Setup Employee Leave Allocation Admin View - Part 1
• Setup Employee Leave Allocation Admin View - Part 2
• Activity: Test and Refactor Admin Allocation
• Setup Employee Leave Allocation - Admin Override
• Activity: Test and Refactor Admin Allocation Edit
• Section Review

Employee Leave Requests Module

• Section Overview
• Module Requirements
• Create Leave Requests Data Model
• Add Entity Configurations and Data Seeding
• Create Controller, Service, and View Models
• Create Leave Request (View and View Model)
• Adding Select List and Form Changes
• Create Leave Request (Queries and Logic)
• Add Leave Request Validation Logic
• Using IValidatableObject
• Activity: Test and Refactor Add Leave Request
• Employee Leave Request List (View and View Models)
• Employee Leave Request List (Service and Logic)
• Employee Leave Request Cancellation Implementation
• FIX: Employee Leave Request Cancellation Bug
• Introducing JavaScript and jQuery Controls
• Add Confirmations to Cancellation Request (jQuery and SweetAlerts)
• Create Admin Leave Request Management (Service and View Model)
• Create Admin Leave Request Management (View)
• Create Admin Review (Service and Models)
• Create Admin Review (View)
• Activity: Test Admin Approval Steps
• FIX: Allocation Period Limitation
• Refactor Repetitive Code
• Add Third-Party Calendar Control
• Add Query String to Leave Request Navigation
• Add Authentication Policy for Roles
• Review and Add Changes to GitHub
• Section Review

Advanced Architecture Concepts

• Section Overview
• Different Project Architecture Layouts
• Separating Project Concerns - Data and Common Concerns
• Separating Project Concerns - Application Concerns
• Separating Project Concerns - Verifying Functionality
• IMPORTANT: EF Core Migrations
• Exception Handling
• Implement Logging with Serilog (Files)
• Implement Logging to Seq
• Additional Identity Configurations and Activities
• Section Review

Advanced UI Concepts

• Section Overview
• Adding Multiple Layouts
• Adding a Custom Layout - Part 1
• Adding a Custom Layout - Part 2
• Customizing Navbar
• Customize Login Page
• Customize Registration Page
• FIX: Registration and Login Form Actions
• Adding Logos and Favicons
• Add Email Template
• Review and Add Changes to GitHub
• Section Review

Deploying to Internet Information Services

• Section Overview
• What is Internet Information Services?
• Setup IIS Locally (Windows)
• Setup .NET Hosting Runtime
• Understanding Environments and Configurations
• Publish ASP.NET Core (Visual Studio)
• Publish ASP.NET Core (CLI)
• Setup IIS Website and App Pool
• Database Deployment Steps and Tips
• Create Database and Users
• Script Migrations and Populate Database
• Configure Local DNS Record
• Additional Considerations
• Section Review

Deploying to Microsoft Azure

• Section Overview
• What is Microsoft Azure?
• Create a Microsoft Azure Account
• Understanding Azure SQL
• Create Database in Azure SQL
• Connecting to SQL Server
• Scripting the Database
• Understanding Azure App Services
• Create Azure App Service
• Deploy To App Service (Using Local Azure Tools)
• Connect App Service to Azure SQL Service
• Section Review

Conclusion

• Conclusion