Update stored procedure did not work in Entity Framework

Question

I wrote the following code, according to this post: CRUD Operations using stored procedure in Entity Framework

using (var context = new SamenEntities())
{
    try
    {
        register pazhoheshgar = new register()
        {
            id = textBox1.Text.Trim(),
            name = textBox2.Text.Trim(),
            family = textBox3.Text.Trim(),
            birth_date = dateTimePicker1.Value,
            mobile = textBox8.Text.Trim(),
            email = textBox11.Text.Trim()
        };
        pazhoheshgar.id= textBox1.Text.Trim();
        context.SaveChanges();

        MessageBox.Show("OK!!!", "Done");
    }
    catch
    {
        MessageBox.Show("ERROR!!!", "error");
    }
}

I already used insert and delete stored procedure, without problem, but now the "DONE!!!" message is displayed, but the change does not occur in the database.

Firstly there is no stored procedure here, secondly your not updating anything you are adding/inserting, thirdly even for an add/insert you forgot to add it to the dbset — TheGeneral
– TheGeneral, Commented Sep 8, 2018 at 13:56

Todd Skelton · Accepted Answer · 2018-09-08 13:56:11Z

2

You have to add the new object to the dbset. If it's called registers then the code would be as follows.

context.registers.Add(pazhoheshgar);

answered Sep 8, 2018 at 13:56

Todd Skelton

7,2873 gold badges39 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Update stored procedure did not work in Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related