Entity Framework - Insert Update and Delete in C#

[@CodAffection]

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]

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

[@valeriusmegamozg]

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]

thanks for the wonderful feedback!.

[@Brianseb]

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.

[@shifasvn3256]

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.

[@samsamry9179]

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

[@hazelannmacaraig8155]

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

[@TIAGO543211]

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]

thanks for your wonderful feedback.

[@tohidulislam5041]

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.

[@user-pw9mp6uk1t]

Thank You.

[@khizerhussain8313]

Very Helpful Video! Thank You

[@waqarahmadqureshi6948]

thankyou... its helpful

[@PalashBansal]

very concise and to the point. Thanks :)

[@CodAffection]

Glad it was helpful!

[@bejanniku]

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

[@2005Azm]

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

[@CodAffection]

Thanks Man.

[@alikemalkulful]

Perfect explanation. Very clear, Thanks a lot

[@ga7853]

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

[@username-dh4tq]

π :

[@KhalidAfridi1]

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

[@CodAffection]

Great to hear!

[@INDIANSinghX]

Dude u did great job ,thanks a lot dear

[@atakantekoglu5520]

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

[@CodAffection]

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

[@atakantekoglu5520]

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

[@KL-gc2hx]

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

[@user-gu3kj6gy8q]

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

[@alirezakazemi5318]

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

[@CodAffection]

Glad it was helpful!

[@bishangiri677]

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

[@stevenyaga]

Very very helpful video

[@christosioannou7359]

Best video ever seriously!!! THank you very much

[@skillshared3249]

Thank you so much. This is great tutorial.

[@tusharkantidas4622]

Awesome job sir...

[@just_kidding_kid]

Thanks Helped Regards from Ukraine

[@CodAffection]

Happy Coding. Stay Safe.

[@just_kidding_kid]

@@CodAffection thanks ❤

[@manojrathore85]

Excellent video

[@mustaphaELHOURA]

very helpful thank you so much

[@nsh8255004]

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

[@phattainguyen7545]

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.

[@odehanas]

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

[@kavindutharaka2273]

very clear explanation. Thank you very much.

[@mikolajsemeniuk8574]

Very helpful !

[@traderasapassion7760]

It's really helpful

[@pocomomo310]

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

[@arslanjappa4335]

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]

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

[@cholemoore5733]

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

[@CodAffection]

glad you found the video helpful.

[@elegeblege1618]

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

[@denzoV2]

you dead or alive?

[@skillshared3249]

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

[@PabloPellegrini]

Perfect explication!! Thank you from Argentina! ♥

[@CodAffection]

glad you found the video helpful.

[@2005Azm]

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

[@CodAffection]

that's coming up next week.

[@kumaresha3348]

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

[@theethicalh3707]

thank you very much bro

[@akramtester5249]

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

[@CodAffection]

Glad you found the video helpful.

[@BahawalTV]

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

[@tjensen529]

Excellent video. Thanks much!

[@UBOINIK_TanksBlitz]

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

[@mjkl614]

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!

[@CodAffection]

:)

[@mscamarade3413]

Thanks, very mach! Very useful video

[@abadd0n297]

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

[@ThumbIKR]

Owwww, really great tutorial sir, thanks :)

[@edvardpotapenko]

Thank you very much, that was very helpful!

[@TheThinker-ug3wr]

great tutorial and its worked good

[@nvidiapersy]

what visual studio did you use ?

[@amirhamzasabuz7977]

Thank you

[@jaberramadandabash2973]

waiting for printing reports operation :D

[@muhammadafzal237]

How to calculate sum of a column values?

[@osempo]

Cool video, easy to follow.

[@danilobastos6182]

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?

[@fabiofocking382]

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

[@CodAffection]

thanks for sharing your comment.

[@sanianaqvi4987]

Thanks a lot

[@mrgonzolla]

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

[@CodAffection]

glad you found the video description.

[@jeffsonic]

great job

[@rafaelramos8220]

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

[@CodAffection]

you are welcome.

[@robertmcdonough1084]

Awesome video! This helped me so much

[@mazkaibil9108]

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

[@CodAffection]

not yet.

[@whopawan8384]

Thanks, Man very helpful

thanks very much Ad

[@Trakai2009]

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

[@Gus-px7hd]

Very useful, Thank you.

[@sathishchowdary8346]

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.

[@peteandalie]

Do your own homework.

[@ga7853]

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

[@username-dh4tq]

× :π•√ .jam π

[@username-dh4tq]

_ #flash :

[@papamagueye6090]

It is so clear... nice job

[@CodAffection]

thanks for the comment.

[@johnsimbe991]

Helpful video, thank u sir!

[@blazept567]

Thank you very much, Sir!

[@altaymahmudi6385]

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

[@johnpaolodelrosario6792]

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

[@ronaldkiefer3565]

Boom Thanks video tutorial was very helpful so far

[@CodAffection]

glad you found the video helpful.

[@learncodego1724]

big like for you

[@hajerjalloul7311]

good !! it's helpful

[@talithasouza1298]

simples e muito bom, ajuda muito

[@NguyenLuan-xn4ym]

So Useful, Thank to u 😃

[@CodAffection]

Welcome 😊

[@humayunnasir6261]

VERY GOOD VIDEO THANKS ALOT

[@militoelynea]

I LOVE YOU!

[@mballo3516]

wonderfull ! Thank you very much !

[@CodAffection]

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

[@zerosandones7547]

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

[@nelpro]

Bro, you're the best!

[@CodAffection]

thanks man.

[@waseembaltistani]

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

[@orthodoxx366]

mantap gaan

[@heinoplaatjies5334]

That was a great clean example, i have tried to do a similar exercise but with an extra field, called section, i used data binding to bind the combobox to a table called sectionTable, when you click on the combobox it dropsdown with a list of all the sections, which is displaying the "Display members", and the "value member" = sect_id. but trying to add a new user to the users table, it gives me an Entity Framwork validation error. System.Data.Entity.Validation.DbEntityValidationException: Validation failed for one or more entites here is my code: private void btn_AddUser_Click(object sender, EventArgs e) { users.Name = txt_userName.Text.Trim(); users.Surname = txt_userSurname.Text; users.Email = txt_userEmail.Text; users.CellNo = Convert.ToInt32(txt_userCell.Text); users.OfficeNo = Convert.ToInt32(txt_userOffice.Text); users.LicNo = Convert.ToString(txt_userLicNo.Text); users.ID_No = Convert.ToInt32(txt_userID.Text); users.Role_id = cbox_RoleName.SelectedIndex; users.Sect_id = cbox_SectionName.SelectedIndex; users.Username = txt_userUsername.Text; users.Password = BCrypt.Net.BCrypt.HashString(txt_userPassword.Text); using (BookingVEHEF ef = new BookingVEHEF()) { ef.Users.Add(users); ef.SaveChanges(); };

[@qurbansaberi479]

Hi bro Can make video about how to insert picture into database how update and how to convert jpg file into bytes

[@daniela4334]

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]

That's dgvCustomers. data grid view Customers ID.

[@AaBb-nn9pl]

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

[@Babaelow]

19:30 how the refresh of the view is done

[@shashanktiwari8180]

Void PopulateDataGridView() { using (DBEntities db = New DBEntities ()) {dgvCustomer.DataSource = db.Customers.ToList(); } } Error on( dgvCustomer ) Error is The name is 'dgvCustomer' does not exist in the current context . Please help

[@Roshan_Panwar]

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

[@mstemper7345]

Did you fix yours? Mee too same problem

[@Roshan_Panwar]

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

[@Roshan_Panwar]

@@mstemper7345 kzbin.info/www/bejne/inqkgKVoiJtgibs

[@Roshan_Panwar]

This will help

[@mstemper7345]

@@Roshan_Panwar THANK YOU!!!!

[@marcelo.junior2478]

My SaveChanges(); and Clear(); don't work.

[@safwanperincheri3453]

Cannot implicity convert type string to byte

[@safwanperincheri3453]

Plse solve this

[@tunguyenminh8423]

Can you explain to me about code-lines: if (model.CustomerID == 0)//Insert { db.Customers.Add(model); } else //Update { db.Entry(model).State = System.Data.Entity.EntityState.Modified; } Thanks a lot!