I am working with a database in which every table has four stamp fields:

CREATEDATE
CREATEUSER
MODIFYDATE
MODIFYUSER

Back in my typed dataset days, I used a custom CommandBuilder that automatically adds these fields to the generated INSERT and UPDATE statements. Is there anywhere in nhibernate that I can hook into to transparently fill these fields?

Just thought I'd ask before adding the four properties to all my objects (or creating a base object with them and inheriting everything from that) and making sure they

Take a look at: 3.1.8. timestamp

If it doesn't solve your problem, give more details (when do you want this fields to be set and with which values ?)

I have the same situation with the simple audit fields. What I did is create an Audit component in each of my mappings that reflects the audit properties.

So I access the audit fields like this. user.Audit.DateCreated. Of course you don't have to take the component route if you want your audit data accessible right oiff of your root object.

Regardless each class that has the audit data implements the IAuditable interface.

I then use an interceptor to update the appropriate fields automatically when a persistence operation is performed.

Thanks, that looks like a very useful hook...

I am new to NHibernate. I am trying to do the same, can you please post some code snippets or link to a sample implementation
Cheers

Please see NHibernate Ref Doc version 1.0.2
if PDF see page 73

search for Interceptors or goto section 9.10