Asp.Net Web Application With SQL Server And Crud Operations

What you'll learn
Create SQL Server databases and tables using Visual Studio 2022
Create ASP .NET web applications using Razor pages
Connect ASP .NET applications with SQL Server using SqlClient (ADO dot NET)
Perform CRUD operations: Create - Read - Update - Delete
Requirements
Intermediate experience with C#, SQL, HTML and Visual Studio 2022
Description
This course is for Beginners to ASP.NET having some knowledge of C#.In this course I will show you:- How to create an ASP.NET Core Web Application with Razor Pages- How to create databases, tables and data into SQL Server using Visual Studio 2022- How to create Razor Pages: full Razor Page (View + Model) and View alone- How to add new items to the menu of the application using the layout file: _Layout.cshtml- How to perform CRUD operations (Create, Read, Update and Delete) on the database using ASP.NET and ADO (no Entity Framework)In this course, I will show you how to use SqlClient to connect to the database and to execute SQL queries. So we will not use Entity Framework for now.To follow this course, you need to install the following tools- Visual Studio 2022- Microsoft SQL ServerAlso it is necessary to install two components into Visual Studio: "ASP.NET and web Development" and ".NET Desktop development"In this course, we will use Visual Studio 2022 to connect to the SQL Server and to create the data. So we don't need to install SSMS (SQL Server Management Studio)Finally, you can download the source code of this project.
Overview
Section 1: ASP.NET Web Application
Lecture 1 Introduction
Lecture 2 Create ASP.NET project
Lecture 3 Create sql server database
Lecture 4 Install SqlClient package
Lecture 5 Read the clients from the database
Lecture 6 Create new clients
Lecture 7 Update clients
Lecture 8 Delete clients
Lecture 9 Source Code
C# and .NET developers who want to learn how to perform CRUD operations using ASP .NET and SQL Server Database
Homepage

https://www.udemy.com/course/aspnet-web-application-with-crud-operations/