BLAZOR – CRUD WITH DATABASE CONNECTION AND UI WITH MUDBLAZOR IN NET 6 || PUSHING TO GITHUB INCLUDED
In this video, I show you how to build a blazor server application with an SQLServer Database connection which allows us to perform CREATE, READ, UPDATE and DELETE (CRUD) Functionalities on the connected Databse.
The User Interface is built using MudBlazor UI Component Library.
Also included is how you can set up your github repository for the project.
Resources
1. What is Blazor?
https://dotnet.microsoft.com/en-us/apps/aspnet/web-apps/blazor
2. You can find this project on github: https://github.com/TheCSharpProgrammer/EmployeeManagement
NB: You need to be signed into github to be able to access the repository link above.
3. Download Vidual Studio:
https://visualstudio.microsoft.com/vs/
4. Download SQLServer Management Studio:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
5. Download SQLServer:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads?rtc=1
6. Download GitHub Desktop
https://desktop.github.com/
Contents
00:00:00 Introduction
00:02:40 Project Demo
00:05:30 How to download the project from github
00:06:27 Create project
00:09:40 Clean Project
00:14:27 Upload to github
00:18:00 Install Nuget Packages
00:22:28 Add new project (Class Library)
00:26:03 Adding Models
00:32:53 Create DBContext
00:39:44 Register DbContext
00:43:40 Make Connection String
00:46:50 Open Sql Srver Management Studio
00:47:55 Running Migrations
00:50:42 Update Database
00:52:37 Commit and Push to Github
00:54:57 Add Interfaces and Services
01:19:40 Register Services
01:24:22 Install Mudblazor
01:31:52 Create Department Page UI
02:34:18 Testing Department Page
02:37:35 Create Employee Page
03:00:29 Testing Employee Page
03:01:40 Call Js Confirm Function
03:04:04 Conclusion