Entity Framework - Insert Update and Delete in C#

Поделиться
HTML-код
  • Опубликовано: 12 дек 2024

Комментарии • 179

  • @CodAffection
    @CodAffection  7 лет назад

    goo.gl/RFY5C2 : Subscribe to CodAffection
    goo.gl/SUi4bg : Login Window in C# Using SQL Server
    goo.gl/zV892S : C# CRUD Operations With SQL Server
    goo.gl/bPcyXW : Buy me a Coffee

    • @khushbujoshi7356
      @khushbujoshi7356 4 года назад

      your skill talents shows everything...your speech is too good.don't think too much on that.keep it up.👍👍👍

  • @Brianseb
    @Brianseb 2 года назад +1

    Gracias Maestro, 5 años tiene el video y sos el único que en todo internet que sabe enseñar como hacer un Update en Entity.

  • @valeriusmegamozg
    @valeriusmegamozg 6 лет назад +12

    It's a very helpful video! Thank you very much, you've just closed all points in 30 minutes much better than my lecturer in 1 week. Thank you!

    • @CodAffection
      @CodAffection  6 лет назад +2

      thanks for the wonderful feedback!.

  • @shifasvn3256
    @shifasvn3256 2 года назад

    you helped me to begin my learning of winforms and i have learned it in one day.i have 2 years experience in .net core and entity framework.this helped me to posses knowledge about winforms ,it was necessary for me because the new company which i got a new offer needed winforms.

  • @TIAGO543211
    @TIAGO543211 5 лет назад

    this channel is the better one, im not even a fluent english speaker but i understand better than people teaching from my own country, i really appreciate your channel bro!!

    • @CodAffection
      @CodAffection  4 года назад +1

      thanks for your wonderful feedback.

  • @samsamry9179
    @samsamry9179 3 года назад +3

    Superb one,
    Really worked very well and made easier
    I'm looking forward to seeing search btton function additionally

  • @2005Azm
    @2005Azm 7 лет назад +1

    Such a elegance in your code sir ! Clean , and clear, complexity made simple !

  • @alikemalkulful
    @alikemalkulful 2 года назад

    Perfect explanation. Very clear, Thanks a lot

  • @KhalidAfridi1
    @KhalidAfridi1 3 года назад

    Thumbs Up bro. Excellent explanation of CRUD operation of using Entity Framework. You saved a lot of my time. Thanks

  • @PalashBansal
    @PalashBansal 4 года назад +1

    very concise and to the point. Thanks :)

  • @atakantekoglu5520
    @atakantekoglu5520 4 года назад

    Thank you very much. It is so educational for me. You are a very brilliant instructor. Keep going!

    • @CodAffection
      @CodAffection  4 года назад +1

      Thanks for your wonderful feedback. let me know your topic suggestion for future tutorials.

    • @atakantekoglu5520
      @atakantekoglu5520 4 года назад

      @@CodAffection Nowadays, I try to learn .Net MVC. Maybe, you can focus on it and also, it is better to create full blog project or etc. with MVC. Thank you.

  • @tohidulislam5041
    @tohidulislam5041 3 года назад

    I use C# winform for 7 years and used parameterized query and never tried EF of fear of learning. After seeing this video all fears gone and feel interested on it. From now for my new project I will try to use EF.

  • @khizerhussain8313
    @khizerhussain8313 2 года назад +1

    Very Helpful Video! Thank You

  • @bejanniku
    @bejanniku 5 лет назад

    Dude, your English is perfect. But that TABL instead of table really cracks me up! good work tho

  • @ga7853
    @ga7853 5 лет назад +3

    Thank you so much, that was so clear and understood, I appreciate your efforts for making this great video, Thanks again

  • @christosioannou7359
    @christosioannou7359 4 года назад

    Best video ever seriously!!!
    THank you very much

  • @alirezakazemi5318
    @alirezakazemi5318 4 года назад

    This was very easy to follow and practical. Thanks so much!

  • @nsh8255004
    @nsh8255004 4 года назад

    it was super perfect tutorial. waiting more from you. thanks alot.

  • @KL-gc2hx
    @KL-gc2hx 3 года назад

    Thank you very much! Learn a lot from your video!

  • @ДимаКалалб-о8ш
    @ДимаКалалб-о8ш 5 лет назад +1

    Oh man! Thank you very much for this tutorial. Sorry of my english. I'm from Russia)

  • @abadd0n297
    @abadd0n297 4 года назад

    Who's the man? You're the man! :D

  • @kavindutharaka2273
    @kavindutharaka2273 5 лет назад +1

    very clear explanation. Thank you very much.

  • @skillshared3249
    @skillshared3249 3 года назад

    Thank you so much. This is great tutorial.

  • @PabloPellegrini
    @PabloPellegrini 5 лет назад

    Perfect explication!! Thank you from Argentina! ♥

  • @INDIANSinghX
    @INDIANSinghX 3 года назад

    Dude u did great job ,thanks a lot dear

  • @hazelannmacaraig8155
    @hazelannmacaraig8155 4 года назад +3

    Hi sir .Thank you for this tutorial. I would like to ask how if one of the columns in database was integer not string . is it possible to run without any convertion? if not can how can i insert data to the sql that have different data types? Hope to hear from you soon. Thanks in advance

  • @cholemoore5733
    @cholemoore5733 6 лет назад

    Thanks. Great video! Well explained. Only wish that I found this video earlier for my assignment.

  • @pocomomo310
    @pocomomo310 3 года назад

    It was so helpful!! Thank you very much. Much appreciated.

  • @tjensen529
    @tjensen529 5 лет назад

    Excellent video. Thanks much!

  • @osempo
    @osempo 5 лет назад

    Cool video, easy to follow.

  • @waqarahmadqureshi6948
    @waqarahmadqureshi6948 3 года назад +1

    thankyou... its helpful

  • @rafaelramos8220
    @rafaelramos8220 6 лет назад

    That was a good video, I'm coming back to code world and it helped me a lot.

  • @robertmcdonough1084
    @robertmcdonough1084 5 лет назад

    Awesome video! This helped me so much

  • @ThumbIKR
    @ThumbIKR 6 лет назад +1

    Owwww, really great tutorial sir, thanks :)

  • @just_kidding_kid
    @just_kidding_kid 2 года назад

    Thanks
    Helped
    Regards from Ukraine

  • @TheThinker-ug3wr
    @TheThinker-ug3wr 5 лет назад +1

    great tutorial and its worked
    good

    • @nvidiapersy
      @nvidiapersy 5 лет назад

      what visual studio did you use ?

  • @mjkl614
    @mjkl614 6 лет назад

    I can hear chicken clucking in the background, you must woke up real early and made these videos, great job, keep up the good work!

  • @tusharkantidas4622
    @tusharkantidas4622 4 года назад

    Awesome job sir...

  • @edvardpotapenko
    @edvardpotapenko 5 лет назад

    Thank you very much, that was very helpful!

  • @UBOINIK_TanksBlitz
    @UBOINIK_TanksBlitz 3 года назад

    Большое спасибо! Ваше видео очень помогло мне!

  • @mscamarade3413
    @mscamarade3413 4 года назад

    Thanks, very mach! Very useful video

  • @fabiofocking382
    @fabiofocking382 5 лет назад

    Wonderfull, this video save my projetc! thank you for this tutorial.

  • @mrgonzolla
    @mrgonzolla 5 лет назад

    Thank you for this video. I found it very helpful!

    • @CodAffection
      @CodAffection  5 лет назад

      glad you found the video description.

  • @papamagueye6090
    @papamagueye6090 6 лет назад

    It is so clear... nice job

  • @manojrathore85
    @manojrathore85 2 года назад

    Excellent video

  • @stevenyaga
    @stevenyaga 4 года назад

    Very very helpful video

  • @whopawan8384
    @whopawan8384 5 лет назад

    Thanks, Man very helpful

  • @ga7853
    @ga7853 6 лет назад

    Thank you so much for this wonderful efforts, and thank you again for the source code, you have made easy for us. Grateful.

  • @ronaldkiefer3565
    @ronaldkiefer3565 6 лет назад

    Boom Thanks video tutorial was very helpful so far

  • @Gus-px7hd
    @Gus-px7hd 6 лет назад

    Very useful, Thank you.

  • @mikolajsemeniuk8574
    @mikolajsemeniuk8574 3 года назад

    Very helpful !

  • @traderasapassion7760
    @traderasapassion7760 3 года назад

    It's really helpful

  • @nelpro
    @nelpro 5 лет назад

    Bro, you're the best!

  • @johnsimbe991
    @johnsimbe991 6 лет назад

    Helpful video, thank u sir!

  • @blazept567
    @blazept567 6 лет назад

    Thank you very much, Sir!

  • @NguyenLuan-xn4ym
    @NguyenLuan-xn4ym 4 года назад

    So Useful, Thank to u 😃

  • @akramtester5249
    @akramtester5249 5 лет назад

    Hi mr. I viewed your video twice, actually very nice, when you using new way to make connection in page load. actually I always use sqldatasource tool to make connection and get data to another toll(gride view ot ditails view), am trying to mix your method with mine,..thanks

  • @phattainguyen7545
    @phattainguyen7545 4 года назад

    Thanks for video. Do i can use db.Entry(model).State = System.Data.Entity.EntityState.Deleted; and saveChanges() to delete without using Detached and Attach(model) ? Thank you for reading.

  • @bishangiri677
    @bishangiri677 3 года назад +1

    Guru is it possible to sync sql database to web server in c sharp desktop app

  • @skillshared3249
    @skillshared3249 3 года назад

    What do you fetch the entity from the database for edit ? You can get it from the grid itself.

  • @humayunnasir6261
    @humayunnasir6261 5 лет назад

    VERY GOOD VIDEO THANKS ALOT

  • @kumaresha3348
    @kumaresha3348 4 года назад

    Great video Brother. Please create video using MySQL for the same Entity. It is very interesting to learn C# Windows Application.

  • @mballo3516
    @mballo3516 4 года назад

    wonderfull ! Thank you very much !

    • @CodAffection
      @CodAffection  4 года назад +1

      thank you, let me know if you have any topic suggestion for future videos.

  • @elegeblege1618
    @elegeblege1618 5 лет назад +1

    That rooster in the background is killing me 29:41
    However, thank you so much for tutorial !!

    • @denzoV2
      @denzoV2 5 лет назад

      you dead or alive?

  • @hajerjalloul7311
    @hajerjalloul7311 6 лет назад +2

    good !! it's helpful

  • @jaberramadandabash2973
    @jaberramadandabash2973 6 лет назад +2

    waiting for printing reports operation :D

  • @2005Azm
    @2005Azm 7 лет назад +2

    Great tutorial as always !! sir can please make an example with more than on table ? like a relational database..?

  •  5 лет назад

    thanks very much Ad

  • @theethicalh3707
    @theethicalh3707 4 года назад

    thank you very much bro

  • @limon8365
    @limon8365 5 лет назад

    very helpful thanks a lot

  • @talithasouza1298
    @talithasouza1298 3 года назад

    simples e muito bom, ajuda muito

  • @muhammadafzal237
    @muhammadafzal237 2 года назад

    How to calculate sum of a column values?

  • @mvducatti
    @mvducatti 6 лет назад +1

    I LOVE YOU!

  • @odehanas
    @odehanas 3 года назад

    Thanks for the video .. it's very helpful i followed and every thing is fine but in the delete function i have got this message if possible to help solving it.. "The entity type Boolean is not part of the model for the current context.'"
    thanks again ..

  • @mazkaibil9108
    @mazkaibil9108 6 лет назад

    Hello, very good tutorial. Is there any video showing how to do this application with two related tables? please advise.

  • @BahawalTV
    @BahawalTV 5 лет назад

    Why can't you bind the entity directly to the form controls?

  • @jeffsonic
    @jeffsonic 3 года назад

    great job

  • @NavaneethaKrishnanA
    @NavaneethaKrishnanA 4 года назад

    Thank you.

  • @amirhamzasabuz7977
    @amirhamzasabuz7977 4 года назад

    Thank you

  • @Trakai2009
    @Trakai2009 6 лет назад

    Great video! But how to sort on, for example by Lastname, by code?

  • @sanianaqvi4987
    @sanianaqvi4987 4 года назад

    Thanks a lot

  • @nostradamot
    @nostradamot 6 лет назад

    would like to ask why the state of var entry become detached?

  • @daniela4334
    @daniela4334 6 лет назад

    What is dgcCustomers on 20:03 video...I am doing these steps in wpf forms and dont get it for what it stands for

    • @akashasuri
      @akashasuri 6 лет назад

      That's dgvCustomers. data grid view Customers ID.

  • @zerosandones7547
    @zerosandones7547 5 лет назад

    Can you do something like this but it has a one-to-many relationship? you teach so well! liked and subbed :D

  • @altaymahmudi6385
    @altaymahmudi6385 4 года назад

    can you tell me how we can use Trim with datetimepicker? i am getting error and it is really annoying

  • @waseembaltistani
    @waseembaltistani 6 лет назад

    If you would added "Search" function also then it will be definitely helpful for the viewers.

  • @sathishchowdary8346
    @sathishchowdary8346 6 лет назад

    Its so helpful. Can you develop a sample library application using ASP.NET MVC with different books count and the count should be reduced if any one borrows book. If you do that , It will be great.

  • @1065411
    @1065411 5 лет назад

    how can i search database thru this codes?

  • @Roshan_Panwar
    @Roshan_Panwar 4 года назад

    It's showing Error
    Configuration Exception Un handled
    The entry dbentities have already been added

    • @mstemper7345
      @mstemper7345 4 года назад

      Did you fix yours? Mee too same problem

    • @Roshan_Panwar
      @Roshan_Panwar 4 года назад

      I removed the DB model and used some other way but used the same design... I'll give you link wait..

    • @Roshan_Panwar
      @Roshan_Panwar 4 года назад

      @@mstemper7345 ruclips.net/video/TIAOr2S6-SY/видео.html

    • @Roshan_Panwar
      @Roshan_Panwar 4 года назад

      This will help

    • @mstemper7345
      @mstemper7345 4 года назад

      @@Roshan_Panwar THANK YOU!!!!

  • @arslanjappa4335
    @arslanjappa4335 7 лет назад +2

    sir you always just made crud operaition on text boxes.ur videos will get more appericiation if you include picture,radioboxes combobox and time in crud.bcz i have nt seen such kind of crud operation on youtube.

    • @CodAffection
      @CodAffection  7 лет назад

      thanks for the suggestion, that's coming up next week.

  • @danilobastos6182
    @danilobastos6182 6 лет назад

    I have a problema when I do a double-click to update the row. Appears a message saying that don't find the column with the name 'CustomerID', but the column name is correct. Somebody passed through for the same thing?

  • @learncodego1724
    @learncodego1724 2 года назад

    big like for you

  • @Ствол22см
    @Ствол22см 4 года назад

    it is a pity that it is not in Russian, thank you man, I am from Russia

  • @karunakamble7277
    @karunakamble7277 2 года назад

    Can I do the same in webform

    • @CodAffection
      @CodAffection  2 года назад

      Sure

    • @karunakamble7277
      @karunakamble7277 2 года назад

      Only delete code is not working. I did this way. In the button click event:
      using (Database1Entities db = new Database1Entities())
      {
      int id = Convert.ToInt32(TextBox1.Text);
      var result = db.tablename.Where(x => x.Id == id).First();
      db.tablename.Remove(result);
      db.SaveChanges();
      var list = db.tablename.ToList();
      Response.Write("Data deleted successfully");
      }
      Thank you so much for your help Sir!

  • @Babaelow
    @Babaelow 4 года назад

    19:30 how the refresh of the view is done

  • @anjumanbaqeriaghowari
    @anjumanbaqeriaghowari 7 лет назад

    thanku so much sir

  • @orthodoxx366
    @orthodoxx366 2 года назад

    mantap gaan

  • @safwanperincheri3453
    @safwanperincheri3453 4 года назад

    Cannot implicity convert type string to byte

  • @sohailaslam8090
    @sohailaslam8090 6 лет назад

    Hi thanks for these tutorials can you post a tutorial on asp.net identity . thanks

    • @CodAffection
      @CodAffection  6 лет назад

      it's already there but using web api and angular 5.
      user registration : ruclips.net/video/h85_GT62K6A/видео.html
      login and logout : ruclips.net/video/e8BlURn6SFk/видео.html
      role based authorization : ruclips.net/video/Ks5ADKqPrBQ/видео.html

  • @siboboregienaldh.9536
    @siboboregienaldh.9536 3 года назад

    We cant access the download file sir please make it public the link