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

[@neeteshsingh5079]

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

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Keep learning and supporting

[@CodetheFutureXR]

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

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprpgrammer is my Instagram handle. Keep learning and supporting 👍

[@aenon0]

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

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly connect on WhatsApp [phone] or on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍

[@vishalsinha1883]

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

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍

[@naveenajmeera-cw6ry]

Thank you so much this will helped me superb teaching

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comments. Kindly connect on Instagram.

[@madankuamr6307]

Very good 👍 👍👍

[@lazregbilel6728]

thank you my friend

[@piotrekpiotrek8137]

Hi, i want to call stored procedure which return one value. Im gettin error that my model class need primary key. Is there a way to make class keyless?

[@ManojDeshwal]

Just add one key to the unique id field

[@DevarintiReddykumari]

Thank you sooo much 🙏🙏🙏🙏🙏

[@sarojbala11]

Thanks Brother , Really Helpful.

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogramer is my Instagram handle. Keep learning and supporting

[@ChaitaliPatil-gu9qq]

Thank you Sir

[@kanyarasi8317]

Superbb

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting

[@aaravaadi6964]

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 !

[@ManojDeshwal]

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

[@nirajkumarmehta8854]

@@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

[@niraliraval8734]

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?

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting

[@leonsplaylife]

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

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly connect on WhatsApp [phone] or on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍.

[@ayushsharma-br3lc]

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

[@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?

[@ManojDeshwal]

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 👍

[@vighneshkumar-l1u]

Thanks alot Reply

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. For any queries, kindly ping me on WhatsApp [phone] or connect on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍

[@zamaryshahab1837]

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

[@ManojDeshwal]

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 👍

[@pacmitan]

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 ??

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. Kindly connect on WhatsApp [phone] or on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍

[@princeonukwili996]

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

[@ManojDeshwal]

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

[@ShivamNirmal-f3u]

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

[@13success66]

Thank u sir

[@ManojDeshwal]

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 👍

[@cedrickweslie5900]

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

[@ManojDeshwal]

Hi, welcome to my channel and thanks for the comment. For any queries, kindly ping me on WhatsApp [phone] or connect on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍

[@chaithravasista1622]

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

[@ManojDeshwal]

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 👍

[@chaithravasista1622]

@@ManojDeshwal Thanks for the reply! 😊😊

[@ManojDeshwal]

Welcome 😊

[@KRITHYKESHSK_VLOGS]

thank you

[@rishikumar1089]

Can i do for get function alone ?

[@ManojDeshwal]

Yes, you can do it

[@mohamedsedahmad585]

Thx

[@SoftwareAli-786]

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

[@ManojDeshwal]

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 👍

[@SoftwareAli-786]

@@ManojDeshwal thanks for the reply . I am really appreciate your work.

[@SoftwareAli-786]

Can you please mention video link.in that you use store procedure in c#. With out using ado.net class. Thank you sir

[@attiqazhar8264]

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

[@ManojDeshwal]

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 👍

[@PardeepKumar-lq3wi]

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

[@PardeepKumar-lq3wi]

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?

[@ManojDeshwal]

Hi Pardeep, welcome to my channel and thanks for the comment. Kindly ping me on WhatsApp [phone] or connect on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting 👍

[@guillermomazzari4983]

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

[@ManojDeshwal]

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 👍

[@guillermomazzari4983]

@@ManojDeshwal I managed to figure it out, thanks anyway, sure, ill follow you up on instagram

[@ManojDeshwal]

Sounds great

[@NashlyGonzalez]

Great! Can you pass the code please?

[@ManojDeshwal]

Hey, welcome to my channel and thanks for the comment. Kindly follow me on Instagram @openprogrammer is my Instagram handle. Keep learning and supporting