title: Fluent NHibernate Insert to table with int Identity
body: <p>I'm new to Fluent NHibernate and I am having an issue inserting to a table which has an ID column set as INT IDENTITY(1,1).</p>
  
  <p>My user map is as follows...</p>
  
  <pre><code>public class UserMap : ClassMap&lt;User&gt;
  {
      public UserMap()
      {
          Table("User");
          Id(x =&gt; x.Id).GeneratedBy.Native();
          Map(x =&gt; x.FirstName);
          Map(x =&gt; x.LastName);
          Map(x =&gt; x.Company);
          Map(x =&gt; x.EmailAddress);
          Map(x =&gt; x.Password);
          Map(x =&gt; x.CountryId); 
      }
  
  }
  </code></pre>
  
  <p>I want SQL to handle the identity of the user and I don't want to return anything. I've tried GeneratedBy.Identity() and I keep getting a SQL string that has question marks for the values on insert with the error message "Incorrect Syntax near the Keyword User'.</p>
  
  <p>SQL String :</p>
  
  <p>INSERT INTO User (FirstName, LastName, Company, EmailAddress, Password, CountryId) VALUES (?, ?, ?, ?, ?, ?); select SCOPE_IDENTITY()</p>
  
  <p>Can anyone point me in the right direction???</p>