Это видео недоступно.
Сожалеем об этом.
ASP.NET Web API CRUD Operation Using SQL Server Stored Procedures
HTML-код
- Опубликовано: 16 авг 2024
- 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: bit.ly/3Uo6SXq
➤ Google Pay UPI ID (INDIA): deshwal.03@okicici
Best Programming and Coding Laptops :-
amzn.to/3sUstfr
amzn.to/3hW24Y4
amzn.to/3MAKWW8
amzn.to/3KxzuJ9
amzn.to/3vRLj8D
amzn.to/3pOZozQ
amzn.to/34rNBQF
🎥 MY RUclips GEAR
My Camera - amzn.to/3JWpubo
Main Tripod - amzn.to/3uTVAAs
Vlogging Tripod - amzn.to/3M9t7we
Main Key Light - amzn.to/3EFEfyF
Softbox - amzn.to/3uRTukG
LED Panel Kit - amzn.to/38UkC9X
Teleprompter - amzn.to/3rBhUNg
Main Microphone - amzn.to/36qRqqh
Mic Boom Arm - amzn.to/3hUHzuX
Lavelier Microphone - amzn.to/3JQBds5
C-Stands - amzn.to/3OmAwdr
Recording Laptop - amzn.to/3vqZjEE
Editing laptop - amzn.to/38160Fg
Tools Used : Microsoft SQL Server 18
📻 Recommended Courses
➤ React JS Tutorial : • ReactJS Tutorial for B...
➤ React Router Tutorial : • React Router Tutorial ...
➤ ASP.Net WEB API Tutorial : • ASP.NET Web API tutori...
➤ SQL SERVER Tutorial : • SQL Server Tutorial Fo...
➤ HTML Crash Course: • HTML Crash Course For ...
➤ Payment Gateway Integration : • CCavenue Payment Gatew...
➤ WEB API With SQL SERVER : • ASP NET Web API with S...
Subscribe to this channel
➤ bit.ly/2IaMZUr
Share, Support, Subscribe Now :
RUclips 🎥 : / manojdeshwal
Instagram 📷 : / openprogrammer
Twitter 🐦 : / openprogrammer
Facebook 👍 : / openprogrammer
Website 🌐 : youtubeassistan...
⭐️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. 😊😊 🙏🙏
I have no understanding of Stored Procedure but the way you simply explained it. Hats Off to you. Thanks for the help.
Hi, welcome to my channel and thanks for the comment. Keep learning and supporting
Veryyyyy thank you sir,
I was trying to create and execute api since last 2 days... finally it's done 😊.
Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprpgrammer is my Instagram handle.
Keep learning and supporting 👍
Thank you so much this will helped me superb teaching
Hi, welcome to my channel and thanks for the comments. Kindly connect on Instagram.
Really helpful for me.....the way you explain end to end needs great knowledge and effort. Thanks alot
Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍
Thank you sooo much 🙏🙏🙏🙏🙏
Very good 👍 👍👍
Dayummm dude!!! Bless your soul🙌
Cant help but subscribe!!👌
Hi, welcome to my channel and thanks for the comment.
Kindly connect on WhatsApp +91 8826791246 or on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
thank you my friend
Thank you Sir
Thanks Brother , Really Helpful.
Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogramer is my Instagram handle. Keep learning and supporting
Hello Sir
Can you please let me know the procedure for migration of stored procedure from SSMS TO MYSQL
Superbb
Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting
Thanks for nice work , what i want you have done.
Hi, welcome to my channel and thanks for the comment. I am glad that my work helped you. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍
Thanks alot
Reply
Hi, welcome to my channel and thanks for the comment. For any queries, kindly ping me on WhatsApp +91 8826791246 or connect on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
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 !
Hi, welcome to my channel and thanks for the comment. You can add your service file and then from your service file you can call your respective methods. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting
@@ManojDeshwal
Hay Manoj sir
My name is Niraj from Noida, currently a job Apollo pharmacy It department ,but i want to learn web Api , pls send me your Any contact number thankyou
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?
Hi, welcome to my channel and thanks for the comment. Create a static common class and place the connection string in that class only. After that use the same class to get the connection instance.
Kindly connect and follow me on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
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 ??
Hi, welcome to my channel and thanks for the comment.
Kindly connect on WhatsApp +91 8826791246 or on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
Sir ,can I have code source or git repo for this project.
Please how did you debug this??????...im confused i'm receiving an error of connection timeout at the post request
Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle.
You can put a break point in your web api and check.
Keep learning and supporting
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?
Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting
How did you create this project with a web api and web config in the same solution? What template did you use?
Hi, welcome to my channel and thanks for the comment. Kindly connect on WhatsApp
+91 88267 91246 or on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍.
Thx
Thank u sir
Hi, welcome to my channel and thanks for the comment. Kindly connect and follow me on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
thank you
Can i do for get function alone ?
Yes, you can do it
If i follow that can i get the data from my frontend to sql server
Hi, welcome to my channel and thanks for the comment. For any queries, kindly ping me on WhatsApp +91 8826791246 or connect on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
Hi sir
Can you make on video web Api crud operation using procedure in c#.
Not use ado.net method.
Please its humble request.
Hi, welcome to my channel and thanks for the comment. Kindly watch my latest video. There I used stored procedures. And follow me on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
@@ManojDeshwal thanks for the reply . I am really appreciate your work.
Can you please mention video link.in that you use store procedure in c#. With out using ado.net class.
Thank you sir
I have no Idea Why you create table and stored procedure in master database. please reply
Hi, welcome to my channel and thanks for the comment. Actually I use master for these video tutorials but you can create your own database and use the same. Kindly follow me on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
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
Hi, welcome to my channel and thanks for the comment. It's up to you, you can write your code and logic wherever you want.
Kindly follow me on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
@@ManojDeshwal Thanks for the reply! 😊😊
Welcome 😊
Bro, can we connect on call, need help from you
If I want to create multiple stored procedure on post or put method or select method, how can we do it, like searching through age instead of id or name instead of id,
We want both search by id and search by name, how can we do it?
Hi Pardeep, welcome to my channel and thanks for the comment. Kindly ping me on WhatsApp 91 8826791246 or connect on Instagram @openprogrammer is my Instagram handle.
Keep learning and supporting 👍
Do it with Net Coer please, not framework, thanks!
Hi, welcome to my channel and thanks for the comment. I will release the expected video soon. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍
@@ManojDeshwal I managed to figure it out, thanks anyway, sure, ill follow you up on instagram
Sounds great
Great! Can you pass the code please?
Hey, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting