Generator Studio is a code generation tool that allows you to set up templates using the Velocity Template Language, and then generates files based on your source database structure. It will be continually updated with new features and templates, to keep checking back if you're interested.

To expand on the title a bit: What if I have an identity column in a table, but it isn’t my primary key? Or what if I have a computed column, and need to use the value as soon as I’ve created/saved/updated?

A post on fixing a "failed to lazily initialize a collection, no session or session was closed" related error when using Castle ActiveRecord/NHibernate in a web application, using the SessionScopeWebModule and a configuration tweak.