ASP.NET Web API CRUD Operation Using SQL Server Stored Procedures
📫 Business – deshwal.03@gmail.com
📱 WhatsApp – +91 88267 91246
🌐 Instagram – @openprogrammer
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:
➤ Google Pay UPI ID (INDIA): deshwal.03@okicici
Best Programming and Coding Laptops :-
🎥 MY YOUTUBE GEAR
My Camera –
Main Tripod –
Vlogging Tripod –
Main Key Light –
Softbox –
LED Panel Kit –
Teleprompter –
Main Microphone –
Mic Boom Arm –
Lavelier Microphone –
C-Stands –
Recording Laptop –
Editing laptop –
Tools Used : Microsoft SQL Server 18
📻 Recommended Courses
➤ React JS Tutorial :
➤ React Router Tutorial :
➤ ASP.Net WEB API Tutorial :
➤ SQL SERVER Tutorial :
➤ HTML Crash Course:
➤ Payment Gateway Integration :
➤ WEB API With SQL SERVER :
Subscribe to this channel
➤
Share, Support, Subscribe Now :
Youtube 🎥 :
Instagram 📷 :
Twitter 🐦 :
Facebook 👍 :
Website 🌐 :
⭐️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. 😊😊 🙏🙏
Thank you sooo much 🙏🙏🙏🙏🙏
Sir ,can I have code source or git repo for this project.
Thank you Sir
Thx
Can i do for get function alone ?
Thank you so much this will helped me superb teaching
thank you my friend
Very good 👍 👍👍
thank you
Thaks for this video.
But… I have this when I trayed to call to Get method ….. System.Collections.Generic.List`1. Do you know why ??
Dayummm dude!!! Bless your soul🙌
Cant help but subscribe!!👌
Thanks alot
Reply
Bro, can we connect on call, need help from you
If i follow that can i get the data from my frontend to sql server
How did you create this project with a web api and web config in the same solution? What template did you use?
I am trying to write the same code in a separate class library but i am getting error for fetching connection string even after creating app.config.
When I pass string variable to SQL connection then it throws error that "A filed initialzer can not reference to non static field". Should I create SQL connection in constructor?
Thank u sir
Veryyyyy thank you sir,
I was trying to create and execute api since last 2 days… finally it's done 😊.
Hello Sir
Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL
Hi sir
Can you make on video web Api crud operation using procedure in c#.
Not use ado.net method.
Please its humble request.
While working with Stored Procedures, is it mandatory to write the code inside the values controller or can we write it by creating a new controller ?? Please reply
I have no Idea Why you create table and stored procedure in master database. please reply
Really helpful for me…..the way you explain end to end needs great knowledge and effort. Thanks alot
Thanks for nice work , what i want you have done.
Do it with Net Coer please, not framework, thanks!
Thanks Brother , Really Helpful.
I have no understanding of Stored Procedure but the way you simply explained it. Hats Off to you. Thanks for the help.
Please how did you debug this??????…im confused i'm receiving an error of connection timeout at the post request
Great! Can you pass the code please?
Thanks this video is very helpful. Could you please tell me that REST API CRUD operation is also develop like this code? and also I want to know what is actual difference between WEB API and REST API?
Superbb
Thanks this video is very helpful one small question i have if we want to add service file from there the controller inherit the get put post and delete method then !