title: NHibernate "database" schema confusion [.\hibernate-mapping\@schema]
body: <p>I'm using NHibernate primarily against an MSSQL database, where I've used MSSQL schemas for the various tables.</p>
  
  <p>In my NH mapping (HBM) files, I've specified the schema for each table in the mapping as follows:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
                     auto-import="true"
                     schema="xyz"&gt;                 &lt;!-- schema specified --&gt;
    &lt;class name="Customer"&gt;
      &lt;id name="Id"&gt;
        &lt;generator class="native" /&gt;
      &lt;/id&gt;
      &lt;property name="Name" /&gt;
    &lt;/class&gt;
  &lt;/hibernate-mapping&gt;
  </code></pre>
  
  <p>For my unit testing, I've been experimenting with SQLite, however my mappings fail now as NH reports that the database "xyz" cannot be found.</p>
  
  <p>I understand there is a difference in interpretation of <a href="https://stackoverflow.com/questions/667208/database-schema-confusion">schema</a>, so what is NH's interpretation/implementation, and what is the best approach when using schema's?</p>
  
  <p>BTW: Searching the web using keywords like "nhibernate database schema" doen't yielded anything relevant.</p>