Entity Framework - Update/add value to existing value

Question

In Entity Framework is it possible to add a value to existing value in the database? Currently I have this:

var ent = this.repository.GetSingle(id);
var moreQuantity = 5; // This is calculated in application logic
ent.quantity = ent.quantity + moreQuantity;
this.repository.SaveChanges();

It is possible to do the same in a single database interaction? I mean something like this in SQL:

UPDATE table SET quantity = quantity + {moreQuantity} WHERE id = {id}

Without using ExecuteSqlCommand or ExecuteStoreQuery.

The reason I am asking this is because there is a significant amount of time between the GetSingle and SaveChanges in my application, so I run with some concurrency problems. I manage to solve it with RowVersion and ConcurrencyCheck but I was looking for a better implementation.

Thanks in advance.

which version of EF are you using?

Mike
– Mike

2015-12-07 14:22:38 +00:00
Commented Dec 7, 2015 at 14:22 — Mike
– Mike, Commented Dec 7, 2015 at 14:22
@MikeMazmanyan Hi, 6.1.1

Hugo Rocha
– Hugo Rocha

2015-12-07 14:25:14 +00:00
Commented Dec 7, 2015 at 14:25 — Hugo Rocha
– Hugo Rocha, Commented Dec 7, 2015 at 14:25

Mike · Accepted Answer · 2015-12-07 14:26:15Z

2

There is a nice library EntityFramework.Extended

Install it and write:

context.repository.Update(e => e.id == id, e2 => new entity { quantity = e2.quantity + moreQuantity });

answered Dec 7, 2015 at 14:26

Mike

4,0713 gold badges22 silver badges32 bronze badges

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

Comments

Alexei - check Codidact · Accepted Answer · 2017-01-24 15:01:47Z

1

Current version of EntityFramework Extended (6.1) has deprecated the overload indicated in the accepted answer. The filtering and the actual update should be separated now. This is a good thing, since filtering can be easily dynamically constructed.

For the actual question, the query should like the following:

context.repository
    .Where(e => e.id == id)
    .Update(e2 => new entity { quantity = e2.quantity + moreQuantity });

answered Jan 24, 2017 at 15:01

Alexei - check Codidact

23.2k22 gold badges159 silver badges179 bronze badges

Collectives™ on Stack Overflow

Entity Framework - Update/add value to existing value

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related