Published 7/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 240.01 MB | Duration: 0h 36m

Create ASP.

NET Application with Razor Pages and SQL Server Database

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 Bners 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 the source code of this project.

Overview

Section 1: ASP.NET Web Application

Lecture 1 Introduction

Lecture 2 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://anonymz.com/https://www.udemy.com/course/aspnet-web-application-with-crud-operations/