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

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

📱 WhatsApp - [phone]
🌐 Instagram - @openprogrammer

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)

Best Programming and Coding Laptops :-

🎥 MY YOUTUBE GEAR

Tools Used : Microsoft SQL Server 18

📻 Recommended Courses

Subscribe to this channel

Share, Support, Subscribe Now :

⭐️Tags : ⭐️

#webapi
#sqlserver
#storedprocedure

⭐️ Topics are covered as follows : ⭐️

connect web api to sql server database
using entity framework with web api
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. 😊😊 🙏🙏

[neeteshsingh]

I have no understanding of Stored Procedure but the way you simply explained it. Hats Off to you. Thanks for the help.

[vishalsinha]

Really helpful for way you explain end to end needs great knowledge and effort. Thanks alot

[swatiraykar]

thank you sir,
I was trying to create and execute api since last 2 days... finally it's done 😊.

[aenon]

Dayummm dude!!! Bless your soul🙌
Cant help but subscribe!!👌

[naveenajmeera-cwry]

Thank you so much this will helped me superb teaching

[ayushsharma-brlc]

Hello Sir
Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL

[zamaryshahab]

Thanks for nice work, what i want you have done.

[aaravaadi]

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 !

[uovdesv]

Sir, can I have code source or git repo for this project.

[niraliraval]

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?

[k_harsh]

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?

[leonsplaylife]

How did you create this project with a web api and web config in the same solution? What template did you use?

[princeonukwili]

Please how did you debug confused i'm receiving an error of connection timeout at the post request

[cedrickweslie]

If i follow that can i get the data from my frontend to sql server

[attiqazhar]

I have no Idea Why you create table and stored procedure in master database. please reply

[pacmitan]

Thaks for this video.
But... I have this when I trayed to call to Get method Do you know why ??

[chaithravasista]

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

[mohdibnealikhan]

Hi sir
Can you make on video web Api crud operation using procedure in c#.
Not use ado.net method.
Please its humble request.

[PardeepKumar-lqwi]

Bro, can we connect on call, need help from you

[guillermomazzari]

Do it with Net Coer please, not framework, thanks!