title: Mapping non-conventional FK column in Fluent NHibernate
body: <p>I have a <code>User</code> class and a <code>Workflow</code> class. A <code>Workflow</code> has a <code>User</code> property on it, relating to the user who created the workflow.</p>
  
  <p>I think I mostly get the basics of Fluent NHibernate now, and have modified the FK convention so the FK field it expects on the <code>Workflow</code> table has a <code>UserId</code> column rather than a <code>User_id</code> column.</p>
  
  <p>All great.</p>
  
  <p>However, I'd like to rename <code>Workflow.User</code> to better illustrate the intent so it becomes <code>Workflow.CreatedByUser</code>.</p>
  
  <p>My FK convention seems to work out the correct property name: <code>CreatedByUserId</code>, and I've been through the hassle of "transient" objects that need saving via <code>Cascade.All()</code>, but now I'm getting exceptions because the <code>Workflow.CreatedByUserId</code> column is <code>NOT NULL</code>, but NH isn't, for some reason, finding a value to put in it. I therefore get a SqlException.</p>
  
  <p>What am I missing?</p>