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

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 พ.ย. 2024

ความคิดเห็น • 66

  • @neeteshsingh5079
    @neeteshsingh5079 2 ปีที่แล้ว +4

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

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว +1

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

  • @CodetheFutureXR
    @CodetheFutureXR ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  ปีที่แล้ว +1

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

  • @naveenajmeera-cw6ry
    @naveenajmeera-cw6ry 11 หลายเดือนก่อน +1

    Thank you so much this will helped me superb teaching

    • @ManojDeshwal
      @ManojDeshwal  11 หลายเดือนก่อน

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

  • @vishalsinha1883
    @vishalsinha1883 2 ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว +1

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

  • @aenon0
    @aenon0 ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  ปีที่แล้ว

      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 👍

  • @madankuamr6307
    @madankuamr6307 ปีที่แล้ว +1

    Very good 👍 👍👍

  • @piotrekpiotrek8137
    @piotrekpiotrek8137 หลายเดือนก่อน +1

    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
      @ManojDeshwal  หลายเดือนก่อน

      Just add one key to the unique id field

  • @kanyarasi8317
    @kanyarasi8317 2 ปีที่แล้ว +1

    Superbb

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

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

  • @lazregbilel6728
    @lazregbilel6728 ปีที่แล้ว +1

    thank you my friend

  • @sarojbala11
    @sarojbala11 2 ปีที่แล้ว +1

    Thanks Brother , Really Helpful.

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

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

  • @DevarintiReddykumari
    @DevarintiReddykumari 5 หลายเดือนก่อน +1

    Thank you sooo much 🙏🙏🙏🙏🙏

  • @zamaryshahab1837
    @zamaryshahab1837 2 ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

      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 👍

  • @ChaitaliPatil-gu9qq
    @ChaitaliPatil-gu9qq 7 หลายเดือนก่อน +1

    Thank you Sir

  • @aaravaadi6964
    @aaravaadi6964 2 ปีที่แล้ว +1

    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
      @ManojDeshwal  2 ปีที่แล้ว +1

      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
      @nirajkumarmehta8854 2 ปีที่แล้ว

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

  • @pacmitan
    @pacmitan ปีที่แล้ว +1

    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
      @ManojDeshwal  ปีที่แล้ว

      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 👍

  • @vighneshkumar-l1u
    @vighneshkumar-l1u ปีที่แล้ว +1

    Thanks alot
    Reply

    • @ManojDeshwal
      @ManojDeshwal  ปีที่แล้ว

      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 👍

  • @leonsplaylife
    @leonsplaylife ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  ปีที่แล้ว +1

      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 👍.

  • @ayushsharma-br3lc
    @ayushsharma-br3lc ปีที่แล้ว +1

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

  • @k_harsh
    @k_harsh ปีที่แล้ว +1

    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
      @ManojDeshwal  ปีที่แล้ว +1

      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 👍

  • @niraliraval8734
    @niraliraval8734 2 ปีที่แล้ว +1

    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
      @ManojDeshwal  2 ปีที่แล้ว

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

  • @princeonukwili996
    @princeonukwili996 2 ปีที่แล้ว +2

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

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

      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

  • @cedrickweslie5900
    @cedrickweslie5900 ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  ปีที่แล้ว

      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 👍

  • @13success66
    @13success66 ปีที่แล้ว +1

    Thank u sir

    • @ManojDeshwal
      @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 👍

  • @ShivamNirmal-f3u
    @ShivamNirmal-f3u 7 หลายเดือนก่อน +1

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

  • @rishikumar1089
    @rishikumar1089 11 หลายเดือนก่อน +1

    Can i do for get function alone ?

    • @ManojDeshwal
      @ManojDeshwal  11 หลายเดือนก่อน

      Yes, you can do it

  • @KRITHYKESHSK_VLOGS
    @KRITHYKESHSK_VLOGS ปีที่แล้ว

    thank you

  • @attiqazhar8264
    @attiqazhar8264 2 ปีที่แล้ว

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

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

      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 👍

  • @chaithravasista1622
    @chaithravasista1622 2 ปีที่แล้ว

    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
      @ManojDeshwal  2 ปีที่แล้ว +1

      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
      @chaithravasista1622 2 ปีที่แล้ว

      @@ManojDeshwal Thanks for the reply! 😊😊

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

      Welcome 😊

  • @mohamedsedahmad585
    @mohamedsedahmad585 9 หลายเดือนก่อน +1

    Thx

  • @SoftwareAli-786
    @SoftwareAli-786 2 ปีที่แล้ว +1

    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
      @ManojDeshwal  2 ปีที่แล้ว +1

      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
      @SoftwareAli-786 2 ปีที่แล้ว +1

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

    • @SoftwareAli-786
      @SoftwareAli-786 2 ปีที่แล้ว

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

  • @PardeepKumar-lq3wi
    @PardeepKumar-lq3wi ปีที่แล้ว +1

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

    • @PardeepKumar-lq3wi
      @PardeepKumar-lq3wi ปีที่แล้ว +1

      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
      @ManojDeshwal  ปีที่แล้ว

      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 👍

  • @guillermomazzari4983
    @guillermomazzari4983 2 ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

      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
      @guillermomazzari4983 2 ปีที่แล้ว +1

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

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

      Sounds great

  • @NashlyGonzalez
    @NashlyGonzalez 2 ปีที่แล้ว +1

    Great! Can you pass the code please?

    • @ManojDeshwal
      @ManojDeshwal  2 ปีที่แล้ว

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