How to update certain columns in db with EF

Question

I am filling my database from json responses with entity framework. Now I also have to update my existing values, or if they allready exists, I have to add them. So if Meeting ID exist, update Attending else add.

My method for adding is working corectlly, but I don't know how to update my values.

Here's my code:

foreach (Event eventItem in obj.events)
{                                         
    using (Entities1 ctx = new Entities1())
    {
        Event1 sas = new Event1
        {
            // ID= autoincr
            // some custom values


            MeetingID=eventItem.eventId   
            //Values to update                            
            Attending=eventItem.attendingCount

        };           
            ctx.Event1.Add(sas);
            ctx.SaveChanges();

    }

}

teo van kot · Accepted Answer · 2016-05-31 08:37:27Z

2

You should get your entities from DB if the are exists:

using (Entities1 ctx = new Entities1())
{
    foreach (Event eventItem in obj.events)
    {                                         
        var ev = ctx.Event1.FirstOrDefault(x=>x.eventId == eventItem.eventId); //get your entity from db (maby you should use other ID)
        if(ev == null) //If have no elements add
        {
            Event1 sas = new Event1
            {
                // ID= autoincr
                // some custom values
                MeetingID=eventItem.eventId,
                //Values to update                            
                Attending=eventItem.attendingCount
            };           
            ctx.Event1.Add(sas);
        }
        else // Else just update
        {
            ev.Attending = eventItem.attendingCount;
        }
    }
    ctx.SaveChanges();
}

Also - it's better not create context for each object so i wrap whole peace of your code in context. This way all changes will be in one transaction.

answered May 31, 2016 at 8:37

teo van kot

12.5k10 gold badges40 silver badges73 bronze badges

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

1 Comment

Sandi Horvat Over a year ago

Thank you very much

Aron · Accepted Answer · 2016-05-31 08:51:41Z

If you know if the item you are trying to Upsert is new/existing. This is the correct code to write.

It is able to do the work in much fewer database calls, resulting in much faster transactions.

using(var ctx = new Context())
{
    foreach (Event eventItem in obj.events)
    {                                         

         Event1 sas = new Event1
         {
             // ID= autoincr
             // some custom values


             MeetingID=eventItem.eventId   
             //Values to update                            
             Attending=eventItem.attendingCount

         }; 
         if(eventItem.eventId != null)
         {          
                ctx.Event1.Add(sas);
         }
         else
         {
                ctx.Entry(sas).State = EntityState.Updated;
         }
    }
    ctx.SaveChanges();
}

Collectives™ on Stack Overflow

How to update certain columns in db with EF

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