Database Generated Date on Insert with NHibernate

Question

Hi,

I am a newbie with NHibernate, so please bear with me.

Let's imagine, i have a property for CreatedDate, and i wanted it to be filled with the sql server datetime value.

The possible solution that i found out is, to mark this property as "generated=always" with "insert=false" and "update=false", and then set the default value for the CreatedDate on sql server level (i mean the database column), to "Getdate()".

Is this the right approach? Thanks for your time, any suggestion will be well appreciated.

Answer 1

You need an nHibernate Audit Interceptor:

http://fgheysels.blogspot.com/2008/07/nhibernate-iinterceptor.html

Answer 2

Here's an example of exactly what you want from the NHibernate community site:

http://nhforge.org/wikis/howtonh/creating-an-audit-log-using-nhibernate-events.aspx

Answer 3

Another solution is to insert the date in SQLServer, when the record is created. Make the column non-nullable, and set its default value to the SQL functon GETDATE(). When the record is created, it will be date/timestamped. Map it in NHibernate like any other DateTime property.

Answer 4

Get the solution from John Rayner. Thanks for all that have helped. thanks for the time