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

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 : https://youtu.be/osGASdatQyw
➤ React Router Tutorial : https://youtu.be/fDBD3E0zxTg
➤ ASP.Net WEB API Tutorial : https://youtu.be/ouiHedLJjTs
➤ SQL SERVER Tutorial : https://youtu.be/cqgVxKdDq3Y
➤ HTML Crash Course: https://youtu.be/65qD_SaiKWA
➤ Payment Gateway Integration : https://youtu.be/CA2IR2AEN7I
➤ WEB API With SQL SERVER : https://youtu.be/ifgZdY3T0Gs

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

Share, Support, Subscribe Now :

Youtube 🎥 : https://youtube.com/ManojDeshwal
Instagram 📷 : https://instagram.com/openprogrammer
Twitter 🐦 : https://twitter.com/openprogrammer
Facebook 👍 : https://facebook.com/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
mvc
asp net
asp.net web api tutorial for beginners
what are restful web services c#
difference between wcf and web api
when to use wcf and when to use web api
wcf rest vs web api
wcf service or web api
asp.net web api vs wcf restful
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. 😊😊 🙏🙏