Entity Framework SaveChanges not updating db

Question

Using sql server profiler I can see that the initial query for AnswerComment is going to the db but when I get to the ef.SaveChanges() nothing is getting to the db. I'm using sqlexpress 2008 R2.

using (TPRDEntities ef = new TPRDEntities())
{
    var ac = ef.AnswerComments.Where(a => a.AnswerCommentID == answercomment.AnswerCommentID).FirstOrDefault();

    if (ac == null)
    {
        ac = new AnswerComment();
        ac.AnswerID = answercomment.AnswerID;
        ac.DisplayText = answercomment.DisplayText;
        ac.InsertDate = answercomment.InsertDate;
        ac.InsertUser = "save test user";
        ef.SaveChanges();
    }
}

Eric J. · Accepted Answer · 2013-08-12 21:13:17Z

6

The new instance you create

ac = new AnswerComment();

is not known to EF. It is a brand-new object instance that EF has not seen before.

You will have to add it to ef.AnswerComments

ef.AnswerComments.Insert(ac);

Also, ensure that ChangeTracking is active for ef.

edited Aug 12, 2013 at 21:13

answered Jul 9, 2012 at 19:05

Eric J.

151k65 gold badges353 silver badges563 bronze badges

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

3 Comments

Eric J. Over a year ago

Wow a downvote to an accepted answer one year later with no comment and no better answer.

schglurps Over a year ago

The downvote is from me, i did a mistake... I cannot undo it until the answer is edited, sorry...

Eric J. Over a year ago

@schglurps: I have edited the answer. Thank you for correcting the accidental downvote.

tanathos · Accepted Answer · 2012-07-09 19:07:46Z

1

I think you miss to add the AnswerComment to the Context, you've to do:

ac = new AnswerComment();
ac.AnswerID = answercomment.AnswerID;
ac.DisplayText = answercomment.DisplayText;
ac.InsertDate = answercomment.InsertDate;
ac.InsertUser = "save test user";

ef.AnswerComments.Add(ac);
ef.SaveChanges();

answered Jul 9, 2012 at 19:07

tanathos

5,6164 gold badges36 silver badges49 bronze badges

Comments

naspinski · Accepted Answer · 2012-07-09 19:07:10Z

0

You are never inserting the new item into the table:

ef.AnswerComments.Insert(ac);
ef.SaveChanges();

answered Jul 9, 2012 at 19:07

naspinski

34.8k38 gold badges120 silver badges176 bronze badges

Collectives™ on Stack Overflow

Entity Framework SaveChanges not updating db

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related