It has the built in CreatedOn, CreatedBy, ModifiedOn, and ModifiedBy columns that you would just need to add to your table. For further audit capabilities I would suggest writing triggers.
I never had any problems with class generation with SubSonic. Are you sure your schema is a good one? Do you follow the conventions? If some tables are not generated, you may be missing PKs, but if you look into the generated classes it will tell you (in a comment) that this is the case. That's all the advice that I can give based on the information provided by you. I still think it's not SubSonic that's the problem...
Using ts As New System.Transactions.TransactionScope()
Using sharedConnectionScope As New SubSonic.SharedDbConnectionScope()
' Do your individual saves here
' If all OK
ts.Complete()
End Using
End Using
Best Answer
It has the built in CreatedOn, CreatedBy, ModifiedOn, and ModifiedBy columns that you would just need to add to your table. For further audit capabilities I would suggest writing triggers.