<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
   <class name="Advisor.Project, Advisor" table="project">
   
      <id name="Id" column="project_id" unsaved-value="0">
         <generator class="assigned"/>
      </id>
      <property name="Name" column="Project_Name" type="String"/>
      
      ....

   </class>
</hibernate-mapping>

2005-12-20 11:14:36,238 [6080] INFO  NHibernate.Cfg.Configuration - searching for mapped documents in assembly: Advisor.Mappings
...
2005-12-20 11:14:37,297 [6080] INFO  NHibernate.Cfg.Configuration - Found mapping documents in assembly: Project.hbm.xml
2005-12-20 11:14:37,297 [6080] INFO  NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2005-12-20 11:14:37,313 [6080] INFO  NHibernate.Cfg.Binder - Mapping class: Advisor.Project -> project
2005-12-20 11:14:37,313 [6080] DEBUG NHibernate.Cfg.Binder - Mapped property: Id -> project_id, type: Int32
2005-12-20 11:14:37,328 [6080] DEBUG NHibernate.Cfg.Binder - Mapped property: Name -> Project_Name, type: String
2005-12-20 11:14:37,328 [6080] DEBUG NHibernate.Cfg.Binder - Mapped property: IsIndirect, type: Boolean
2005-12-20 11:14:37,328 [6080] DEBUG NHibernate.Cfg.Binder - Mapped property: ParentCustomer -> customer_id, type: Customer
....
2005-12-20 11:14:37,391 [6080] DEBUG Advisor.Labels.DataLayerNH - Completed adding assembly [Advisor.Mappings] to configuration
2005-12-20 11:14:37,453 [6080] INFO  NHibernate.Cfg.Configuration - processing one-to-many association mappings
....
2005-12-20 11:14:37,484 [6080] DEBUG NHibernate.Cfg.Binder - Second pass for collection: Advisor.Project.SalesOrders
2005-12-20 11:14:37,484 [6080] INFO  NHibernate.Cfg.Binder - mapping collection: Advisor.Project.SalesOrders -> sales_order
2005-12-20 11:14:37,484 [6080] DEBUG NHibernate.Cfg.Binder - Mapped collection key: project_id, one-to-many: SalesOrder
...
2005-12-20 11:14:37,546 [6080] INFO  NHibernate.Cfg.Configuration - processing one-to-one association property references
2005-12-20 11:14:37,546 [6080] INFO  NHibernate.Cfg.Configuration - processing foreign key constraints
....
2005-12-20 11:14:37,546 [6080] DEBUG NHibernate.Cfg.Configuration - resolving reference to class: Project
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Cfg.SettingsFactory - use outer join fetching: True
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Connection.ConnectionProviderFactory - Intitializing connection provider: NHibernate.Connection.DriverConnectionProvider
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Connection.ConnectionProvider - Configuring ConnectionProvider
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Cfg.SettingsFactory - Optimize cache for minimal puts: False
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Cfg.SettingsFactory - Query language substitutions: {}
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Cfg.SettingsFactory - cache provider: NHibernate.Cache.HashtableCacheProvider
2005-12-20 11:14:37,640 [6080] INFO  NHibernate.Cfg.SettingsFactory - Using Isolation Level: ReadCommitted
2005-12-20 11:14:37,655 [6080] INFO  NHibernate.Cfg.Configuration - instantiating and configuring caches
2005-12-20 11:14:37,671 [6080] INFO  NHibernate.Impl.SessionFactoryImpl - building session factory
2005-12-20 11:14:37,671 [6080] DEBUG NHibernate.Impl.SessionFactoryImpl - instantiating session factory with properties: {hibernate.dialect=NHibernate.Dialect.MsSql2000Dialect, hibernate.connection.isolation=ReadCommitted, hibernate.connection.connection_string=Server=prod-sql-01;Initial Catalog=advisor_dev;Integrated Security=SSPI, hibernate.connection.provider=NHibernate.Connection.DriverConnectionProvider, hibernate.connection.driver_class=NHibernate.Driver.SqlClientDriver}
2005-12-20 11:14:37,749 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 10 for the table label_audit audits0_
2005-12-20 11:14:37,764 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 14 for the SelectSqlBuilder that needed a capacity of: 24 for the table project projects0_
2005-12-20 11:14:37,796 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 10 for the table sales_order salesorder0_
2005-12-20 11:14:37,796 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 10 for the SelectSqlBuilder that needed a capacity of: 14 for the table label_permission_set_indiv labelpermi0_ inner join label_permission_set [labelpermi0__1_] on labelpermi0_.permission_id=[labelpermi0__1_].permission_id
2005-12-20 11:14:37,796 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 10 for the table customer_business_unit businessun0_
2005-12-20 11:14:37,796 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 10 for the SelectSqlBuilder that needed a capacity of: 12 for the table project projects0_
2005-12-20 11:14:37,796 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 10 for the SelectSqlBuilder that needed a capacity of: 14 for the table group_member securitygr0_
2005-12-20 11:14:37,827 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 12 for the table employee_active employee0_
2005-12-20 11:14:37,842 [6080] DEBUG NHibernate.SqlCommand.SqlSelectBuilder - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 16 for the table customer_business_unit customerbu0_
2005-12-20 11:14:37,858 [6080] DEBUG NHibernate.Impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
2005-12-20 11:14:37,858 [6080] DEBUG NHibernate.Impl.SessionFactoryObjectFactory - registered: 54418a224dce42d58b2d5b8d3ca673f2(unnamed)
2005-12-20 11:14:37,858 [6080] INFO  NHibernate.Impl.SessionFactoryObjectFactory - no name configured
2005-12-20 11:14:37,858 [6080] DEBUG NHibernate.Impl.SessionFactoryImpl - Instantiated session factory

NHibernate.MappingException: Unknown entity class: Advisor.Project

public Project LoadProject(int projectId)
{
   ISession session = GetSession();

   Project p = (Project) session.Load(typeof(Project), projectId);
   
   return p;
}


/// <summary>
/// Returns an ISession object to the caller (the session will either be the current session or a new session, depending on when it is called).
/// This method handles determining whether a new session needs to be opened internally.
/// </summary>
/// <returns>An ISession for use in this class</returns>
private static ISession GetSession()
{
   //test if we are running within ASP.NET
   if (HttpContext.Current == null)
   {
      //if we are not, we want to have a session that is static to this application domain
      if (log.IsDebugEnabled) log.Debug("GetSession - using appdomain static session");
      
      if (m_session == null)
      {
         m_session = CreateSession();
      }
      if (log.IsDebugEnabled) log.Debug("GetSession - returning session to caller");
      return m_session;
   }
   else
   {
      //we are running inside of ASP.NET
      //we want to make the session static to the http request
      if (log.IsDebugEnabled) log.Debug("GetSession - using http request static session");

      HttpContext currentContext = HttpContext.Current;

      ISession session = currentContext.Items[HTTP_SESSION_KEY] as ISession;

      if (session == null)
      {
         session = CreateSession();
         currentContext.Items[HTTP_SESSION_KEY] = session;
      }

      return session;
   }
}

/// <summary>
/// Does the actual instantiating of a new session
/// </summary>
/// <returns>A newly opened ISession</returns>
private static ISession CreateSession()
{
   if (log.IsInfoEnabled) log.Info("Instantiating new ISession from factory");
   return nhFactory.OpenSession();
}

static ISessionFactory nhFactory = initializeFactory();

/// <summary>
/// Initializes the ISessionFactory.
/// </summary>
/// <returns>ISessionFactory for this class. Note the use of this method in the declaration of the static nhFactory member.</returns>
static ISessionFactory  initializeFactory()
{
   if (log.IsDebugEnabled) log.Debug("initializeFactory() starting, about to construct Configuration");

   Configuration nhConfig = new Configuration();
   if (log.IsDebugEnabled) log.Debug("Created new NH configuration object");

   nhConfig.AddAssembly( ConfigHandler.HbmAssemblyName );
   if (log.IsDebugEnabled) log.DebugFormat("Completed adding assembly [{0}] to configuration", ConfigHandler.HbmAssemblyName);

   nhFactory = nhConfig.BuildSessionFactory();

   if (log.IsDebugEnabled) log.Debug("Constructed ISessionFactory, returning");

   return nhFactory;
}