NHibernate - Version as DateTime, generated in DB

Question

I'm trying to assign a version column to my table and I want the version to be generated from the DB (getDate()). My mapping looks like that:

Version(x => x.Version).Index("idx_Version").Generated.Always();

but when I'm trying to insert a row, I'm getting this error:

Cannot insert the value NULL into column 'Version'... column does not allow nulls.

I've also tried a different approach and mapped the column as an regular column like this:

Map(x => x.Version).Index("idx_Version").Generated.Always();

but it's generated nulls on that column...

Any ideas?

I believe this tells NHibernate that the DB will be responsible for filling this column. How is the DB handling it? Did you set a default on the column in the DB? — rivarolle
– rivarolle, Commented Jun 16, 2013 at 7:36
I set a default value of getDate() but it generates it only on insert, not on update. How can I set the value for generated field? — Lidor
– Lidor, Commented Jun 16, 2013 at 11:54

Community · Accepted Answer · 2017-05-23 10:32:14Z

2

I guess that you are using MS SQL DB. There are some similar answers:

Summary: implement the trigger on UPDATE to have your column changed even during the UPDATE (not only INSERT with GetDate())

Or (I would suggest this appraoch) use a rowversion which will do for you exactly what you want.

CommunityBot

11 silver badge

answered Jun 17, 2013 at 4:10

Radim Köhler

124k48 gold badges243 silver badges343 bronze badges

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

1 Answer 1