End to End ASP. NET and Entity Framework Development

Overview

Learn how to build an Employee Leave Management System using ASP.Net Core 3.1, Entity Framework, Code-First and the Repository Pattern. This complete course will show you how to use Visual Studio, Microsoft SQL Server Express and explore dynamic web development with Bootstrap and JQuery and various front-end libraries.

ASP.NET Core 3.1 is Microsoft's modern, cross-platform framework for building enterprise ready web applications. In this course,  you will learn everything you need to know about building ASP.NET Core 3.1 applications, from understanding the folder structure and files, to building a complete web application.

Upgrade to .NET 5 *NEW*

.NET 5 is the latest in Microsoft's SDK technologies and while we develop this solution using .NET Core 3.1, we do an upgrade to .NET 5 with very minimal effort. EVERYTHING still works!

Why Learn ASP.NET Core 3.1

Microsoft .NET is the platform that drives the business technology of many of the top corporations in the United States and many other countries. It is the predominant technology used to drive enterprise-scale business technology. Companies have chosen .NET because for its proven scalability, reliability, and support.

The .NET language of choice to learn is C#, as it is among the most widely used languages today. It’s a general purpose programming language that can handle almost any problem, from desktop to mobile to dynamic web applications. As such, there is a high demand across the world for .NET developers in a variety of industries, so that means that more jobs are available for candidates with a foundation built upon .NET technologies.

Build A Strong Foundation in .NET Core Programming:

• Build a fully data driven web application using cutting edge technology

• Connect to a Database using Entity Framework Core

• Repository Pattern and Dependency Injection

• Understand how the MVC (Models, Views and Controllers) Pattern works

• Understand C# and .Net Core Web Syntax

• Understand user Authentication using ASP.NET Core Identity

• Understand how to use Models, ViewModels and AutoMapper

• Use Bootstrap to style and manipulate the overall layout

• Manage Packages with NuGet Manager

• Implement Website Layout using AdminLTE Theme

• Setup GitHub for Source Control

• Setup IIS Server on Local Machine (Or Windows Server)

• Setup Microsoft Azure Account

• Publish .NET Core Application to IIS

• Publish .NET Core Application to Microsoft Azure App Services

Content and Overview

To take this course, you will need to have some knowledge of Object Oriented Programming, if not C#. Even if you do not have much exposure to the .NET development stack, this course is very beginner friendly and chock full of development tips.

This is a huge course. Over 15 hours of premium content, but smartly broken up to highlight a set of related activities based on each module in the application that is being built. We will also look at troubleshooting and debugging errors as we go along; implementing best practices; writing efficient logic and understanding why developers do things the way they do. Your knowledge will grow, step by step, throughout the course and you will be challenged to be the best you can be.

By the time you have finished the course you will have moved around in Visual Studio and examined logic and syntax errors so much, that it will be second nature for you when working in the .NET environment. This will put your new learned skills into practical use and impress your boss and coworkers.

The course is complete with working files hosted on GitHub, with the inclusion of some files to make it easier for you to replicate the code being demonstrated. You will be able to work alongside the author as you work through each lecture and will receive a verifiable certificate of completion upon finishing the course.

• Introduction
• Create a GitHub Account
• Install Visual Studio 2019 Community Edition
• UPDATE: Install Visual Studio 2022 Community Edition and .NET 6
• Create .Net Core Web Application Project
• Tour of ASP.NET Core Application
• Migrate Project to .NET 5
• UPDATE - Migrate Project to .NET 6
• Setup Website Layout
• Setup Database, Models and Migrations
• Setup Repository and Dependency Injection
• Implement Database and Entity Framework Functionality
• Setup ViewModels and AutoMapper
• Review and Add Changes to GitHub
• Setup Leave Type Controller and Actions
• Setup Leave Type Index View
• Setup Leave Type Create View
• Setup Leave Type Edit View
• Setup Leave Type Details View
• Setup Leave Type Delete Function
• Add Leave Type Data Table and Font Awesome Icons
• Review and Add Changes to GitHub
• ASP.Net Core Authentication Overview
• Customizing Registration Page and Process
• Review Login Functionality
• Add Default Roles and Admin User
• Control User Access with Role Authorization
• Review and Add Changes to GitHub
• Leave Allocation Module Overview
• Leave Allocation Module - Database Changes
• Leave Allocation Module - Create View
• Leave Allocation Module - Employee Listing
• Leave Allocation Module - View Leave Allocation Per Employee
• Leave Allocation Module - Edit Leave Allocation Per Employee
• Review and Add Changes to GitHub
• Employee Leave Requests Module Overview
• Employee Leave Requests Module - Database Changes and ViewModels
• Employee Leave Requests Module - Setup Controlledrs
• Employee Leave Requests Module - Setup Admin Index View
• Employee Leave Requests Module - Create Leave Request Part 1
• Employee Leave Requests Module - Create Leave Request Part 2
• Employee Leave Requests Module - Admin Leave Request Review
• Employee Leave Requests Module - Employee Leave Request Views
• Review and Add Changes to GitHub
• AdminLTE Theme Preview
• Create New Layout Page
• Setup AdminLTE and Dependencies
• Essential Layout Fixes and Additions
• Custom Login And Registration Pages
• Review and Add Changes to GitHub
• Asynchronous Repository Functions
• Asynchronous Controllers and Actions
• Review and Add Changes to GitHub
• Review of Programming Patterns
• Implement Generic Repository
• Implement Unit of Work
• Refactor Leave Types Controller
• Refactor Leave Requests Controller
• Refactor Leave Allocations Controller
• UPDATE - Strongly Type Includes for Unit Of Work
• Review of Built in Security Features
• Secure Delete Method
• Send Emails using MailKit and SMTP
• Publish Section Overview
• Setup Internet Information Services (IIS) on a Server
• Publish Application to IIS and SQL Server
• Create Microsoft Azure Account
• Publish to Azure App & SQL Services
• Setup Automated Build/Release Pipeline using GitHub and Azure DevOps
• Publish Review