Update with Entity Framework C#

Question

I want to update items by Entity Framework,

The code is correct but i don't have result in my database!!

using(checkinentrepriseEntities2 context = new checkinentrepriseEntities2()) {
 clients clien = new clients();

 clien.date_arrival = DateTime.Parse(textBoxDateIN.Text);
 clien.arrival_time = textBoxTIME.Text;
 clien.Aller_A = comboboxPersonnel.SelectedItem.ToString();
 clien.Badge = int.Parse(comboBoxBadge.SelectedItem.ToString());

 int badgeTiped = int.Parse(comboBoxBadge.SelectedItem.ToString());

 context.SaveChanges();
}

You're creating a new clients so you will be inserting and not updating in this situation, meaning you also need context.clients.Add(clien) or something along those lines — Alfie Goodacre
– Alfie Goodacre, Commented Nov 8, 2016 at 10:30
do you want add a new Client or update an existing Client? — Masoud
– Masoud, Commented Nov 8, 2016 at 10:30
OH! i make mistake... I want update an existing Client not Add !! Very Thakns!!!! — devtunis
– devtunis, Commented Nov 8, 2016 at 10:38

PMerlet · Accepted Answer · 2016-11-08 10:32:15Z

2

This code is creating a new clients object.

If you want to update results from the database you have to select the clients object from the database :

clients clien = context.clients.Single(x => x.Id == yourId);
// your logic
context.SaveChanges();

answered Nov 8, 2016 at 10:32

PMerlet

2,5944 gold badges25 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

devtunis Over a year ago

That is it !! Thanks!

Yanga · Accepted Answer · 2016-11-08 10:33:34Z

-1

You can try this code:

        using (checkinentrepriseEntities2 context = new checkinentrepriseEntities2())
        {
            clients clien = new clients();

            clien.date_arrival = DateTime.Parse(textBoxDateIN.Text);
            clien.arrival_time = textBoxTIME.Text;
            clien.Aller_A = comboboxPersonnel.SelectedItem.ToString();
            clien.Badge = int.Parse(comboBoxBadge.SelectedItem.ToString());

            int badgeTiped = int.Parse(comboBoxBadge.SelectedItem.ToString());

            context.clients.Add(clien);
            context.SaveChanges();
        }

Just add context.clients.Add(clien);

answered Nov 8, 2016 at 10:33

Yanga

3,0121 gold badge33 silver badges32 bronze badges

Collectives™ on Stack Overflow

Update with Entity Framework C#

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related