title: How can i configure fluent nHibernate connection properties
body: <p>Can someone tell he how i can setup my fluent nhibernate connection to always connect as follows</p>
  
  <ul>
  <li>SET NOCOUNT ON </li>
  <li>SET ARITHABORT ON</li>
  <li>SET NUMERIC_ROUNDABORT ON</li>
  </ul>
  
  <p>this is what i have at the moment </p>
  
  <pre><code>            var fluentConfiguration = Fluently.Configure()
                  .Database(MsSqlConfiguration.MsSql2008.ConnectionString(ConnectionString).ShowSql());
  
              fluentConfiguration = fluentConfiguration.Cache(c =&gt; c
                      .UseQueryCache()
                      .UseMinimalPuts()
                      .ProviderClass&lt;HashtableCacheProvider&gt;());
  </code></pre>
  
  <p>thanks
  Niall</p>