IIRF Online > Development > Web Development > ASP.NET Core > Complete ASP.NET Core and Entity Framework Development
Complete ASP.NET Core and Entity Framework Development by Udemy
Learn ASP.NET Core and Entity Framework by building and publishing a practical Employee Leave Management System.
Course Highlights
- Build Complete Data Driven .NET Core MVC Application From Scratch
- .NET 6 / 8 Development
- Learn C# and Visual Studio Techniques
- Implement Authentication and Authorization functionality with Identity Core
- Repository and Unit Of Work Pattern and Dependency Injection
- Use AutoMapper and View Models
- Build Database using Code First Pattern and Migrations
- Interact with Database using Entity Framework Core
- Use NuGet Package Manager
- Manage and Track Changes using GitHub
- Asynchronous Programming
- Setting up and Publishing to IIS and Remote Database
- Setting up a Microsoft Azure Account
- Publishing to Azure Web and SQL Services
- Setup Automated Build/Release Pipeline using GitHub and Azure DevOps
- Review Application Security Measures
Skills you will learn!
Curriculum
2 Topics
Introduction
IMPORTANT: Course Content Updates
4 Topics
What is .NET?
What is ASP.NET Core?
What Will You Learn in this Course?
What We Are Building
6 Topics
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
15 Topics
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
8 Topics
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
8 Topics
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
Section Source Code
12 Topics
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
Section Source Code
17 Topics
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
Section Source Code
14 Topics
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
Section Source Code
11 Topics
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
Section Source Code
18 Topics
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
Section Source Code
22 Topics
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
Section Source Code
30 Topics
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
Section Source Code
12 Topics
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
Section Source Code
13 Topics
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
Section Source Code
14 Topics
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
12 Topics
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
1 Topic
Conclusion
1 Topic
Bonus Lecture
Complete ASP.NET Core and Entity Framework Development
Related ASP.NET Core Courses
Thank You!
Your review has been submitted successfully.