ASP.NET Web API CRUD Operation Using SQL Server Stored Procedures

Publicado em: 01 Maio 2022
no canal de: Manoj Deshwal

56,702

726

ASP.NET Web API CRUD Operation Using SQL Server Stored Procedures

📫 Business - manojdeshwal.dev@gmail.com
📱 WhatsApp - +91 96257 01241
🌐 Instagram - @manojdeshwal.dev

In this video we will create ASP.NET Web API application which deals with a SQL Server database using stored procedures. We will be using this application just to understand the ASP.NET Web API concepts and its most commonly used methods. This tutorial will help you to understand the Web API Insert Update Delete methods in Asp.net WEB API with Sql Server.

Introduction To ASP.NET Web API :
The term API stands for Application Programming Interface. ASP.NET Web API is a framework for building Web API’s, i.e. HTTP based services on top of the .NET Framework. The most common use case for using Web API is for building RESTful services.

What are RESTful services :
REST stands for Representational State Transfer. REST was first introduced in the year 2000 by Roy Fielding as part of his doctoral dissertation. REST is an architectural pattern for creating an API that uses HTTP as its underlying communication method. The REST architectural pattern specifies a set of constraints that a system should adhere to.

What are SQL Stored Procedures?
SQL Server stored procedures are used to group one or more Transact-SQL statements into logical units. The stored procedure is stored as a named object in the SQL Server Database Server.

Points covered :

1) Use Master Database 00:01:23
2) Create tnew table TestEmployee 00:01:28
3) Create New Web API project 00:01:54
4) Create Employee Model Class 00:04:57
5) Create ConnectionString 00:06:23
6) Create Procedure for Insert Data 00:08:30
7) Create Post Method in Web API 00:09:20
8) Test Post Method By Postman 00:14:25
9) Create Get Method in Web API 00:16:30
10) Create Procedure to Get Data 00:16:56
11) Create Get By Id Method in Web API 00:21:50
12) Create Procedure to Get By Id Data 00:24:09
13) Test Get Method by Postman 00:25:00
14) Test Get By Id Method by Postman 00:25:46
15) Create Put Method in Web API 00:26:15
16) Create Delete Method in Web API 00:27:23
17) Create Procedure to Update the data 00:28:14
18) Create Procedure to Delete the data 00:29:20
19) Create Procedure to Delete the data 00:29:20
20) Create Procedure to Delete the data 00:31:51

☕ Buy me a Coffee (Channel Support through Donation)
➤ Online: https://bit.ly/3Uo6SXq
➤ Google Pay UPI ID (INDIA): deshwal.03@okicici

Best Programming and Coding Laptops :-

https://amzn.to/3sUstfr
https://amzn.to/3hW24Y4
https://amzn.to/3MAKWW8
https://amzn.to/3KxzuJ9
https://amzn.to/3vRLj8D
https://amzn.to/3pOZozQ
https://amzn.to/34rNBQF

🎥 MY YOUTUBE GEAR

My Camera - https://amzn.to/3JWpubo
Main Tripod - https://amzn.to/3uTVAAs
Vlogging Tripod - https://amzn.to/3M9t7we
Main Key Light - https://amzn.to/3EFEfyF
Softbox - https://amzn.to/3uRTukG
LED Panel Kit - https://amzn.to/38UkC9X
Teleprompter - https://amzn.to/3rBhUNg
Main Microphone - https://amzn.to/36qRqqh
Mic Boom Arm - https://amzn.to/3hUHzuX
Lavelier Microphone - https://amzn.to/3JQBds5
C-Stands - https://amzn.to/3OmAwdr
Recording Laptop - https://amzn.to/3vqZjEE
Editing laptop - https://amzn.to/38160Fg
Tools Used : Microsoft SQL Server 18

📻 Recommended Courses
➤ React JS Tutorial :    • ReactJS Tutorial for Beginners | Reac...
➤ React Router Tutorial :    • React Router Tutorial | React For Beg...
➤ ASP.Net WEB API Tutorial :    • ASP.NET Web API tutorial for beginner...
➤ SQL SERVER Tutorial :    • SQL Server Tutorial For Beginners | S...
➤ HTML Crash Course:    • HTML Crash Course For Absolute Beginn...
➤ Payment Gateway Integration :    • CCavenue Payment Gateway Integration ...
➤ WEB API With SQL SERVER :    • ASP NET Web API with SQL Server

Subscribe to this channel
➤ https://bit.ly/2IaMZUr

Share, Support, Subscribe Now :

Youtube 🎥 :    / manojdeshwal
Instagram 📷 :   / openprogrammer
Twitter 🐦 :   / openprogrammer
Facebook 👍 :   / openprogrammer
Website 🌐 : http://youtubeassistance.com/

⭐️Tags : ⭐️

#webapi
#sqlserver
#storedprocedure

⭐️ Topics are covered as follows : ⭐️

asp.net web api entity framework example
connect web api to sql server database
using entity framework with web api
asp.net web api entity framework database first
web api and entity framework 6
entity framework class library connection string
web api
insert update delete
google postman
ASP .NET Web API
Microsoft SQL Server
SQL Server
Full-Stack Web Devleopment
Front-End End Development
Back-End Web Development
Database Development

Thanks for watching. 😊😊 🙏🙏

Nesta página do site você pode assistir ao vídeo on-line ASP.NET Web API CRUD Operation Using SQL Server Stored Procedures duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Manoj Deshwal 01 Maio 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 56,702 vezes e gostou 726 espectadores. Boa visualização!

1,044

112