Entity Framework IsRowVersion() without concurrency check

Question

We have a table that has a column called Version that is mapped as a SQL rowversion. This is done because we have an external system that maps to our data that relies on this column changing every time the table is updated. Originally we wanted this to be handled by SQL, but now we are finding we have Optimistic Concurrency exceptions. While these exceptions are there to safeguard data getting overwritten, for our case we do not care about this. We simply want the timestamp to continue incrementing, without Entity Framework checking it for concurrency issues.

Is there any way to do this?

Mapping:

Property(t => t.Version).IsRowVersion();

Yes, just remove it from your mapping. Sql Server will increment it on each update anyway. — Gert Arnold
– Gert Arnold, Commented May 16, 2017 at 18:49
I tried removing it from my mapping but i get an error: cannot update timestamp column — DLeh
– DLeh, Commented May 17, 2017 at 13:41
Did you actively mark the property as ignored? On second thoughts, why not remove it from your class model altogether? — Gert Arnold
– Gert Arnold, Commented May 17, 2017 at 13:45
We need to be able to use the column in our app as we need to provide the value to another app that uses our api, so removing it from the model is out of the question. The answer below has resolved our problem. — DLeh
– DLeh, Commented May 17, 2017 at 14:05

Ivan Stoev · Accepted Answer · 2017-05-16 19:13:14Z

8

By default EF implies row version type to be a optimistic concurrency token (included in the optimistic concurrency checks).

You can override that behavior by using the IsConcurrencyToken fluent API:

Property(t => t.Version).IsRowVersion().IsConcurrencyToken(false);

answered May 16, 2017 at 19:13

Ivan Stoev

208k17 gold badges356 silver badges376 bronze badges

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

2 Comments

DLeh Over a year ago

I'm going to test this now, if this works I could kiss you

DLeh Over a year ago

works! thank you so much! we've been trying to find the source of these concurrency issues for months

MoishyS · Accepted Answer · 2023-02-21 18:01:03Z

0

In EF core adding IsConcurrencyToken(false) will change the column type from rowversion to varbinary(max).

Instead you should replace IsRowVersion() with HasColumnType("rowversion") like this:

Property(e => e.LastUpdatedRowVer).HasColumnType("rowversion").ValueGeneratedOnAddOrUpdate();

answered Feb 21, 2023 at 18:01

MoishyS

3,0321 gold badge10 silver badges8 bronze badges

Collectives™ on Stack Overflow

Entity Framework IsRowVersion() without concurrency check

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related