NHibernate提示表is not mapped

一定要将hbm.xml映射文件设置成嵌入的资源。

下面是mysql的映射文件：

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
  <class name=" wh.db.test.model.Test, wh.db.test.model" table="test">
    <!--主键-->
    <id name="id" column="id" type="string" unsaved-value="0">
      <!--非自增主键应该配置为assigned属性,自增主键应该配置成native-->
      <generator class="assigned" />
    </id>
    <property name="name" column="name" type="string"/>
    <property name="sex" column="sex" type="int"/>
    <property name="address" column="address" type="string"/>
    <property name="work" column="work" type="string"/>
  </class>
</hibernate-mapping>

下面是oracle的映射文件：

<?xml version="1.0" encoding="utf-8" ?>

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
  <class name="EPAP.SZ.Models.B_R_Szmjobcar, EPAP.SZ.Models" table="B_R_SZMJOBCAR">
    <id name="Jobcarid" column="JOBCARID" type="int">
      <generator class="sequence">
        <param name="sequence">B_R_SZMJOBCAR_SEQ</param>
      </generator>
    </id>
    <!--系统标识-->
    <property name="Epapid" column="EPAPID" type="string" />
    <!--作业分工单ID-->
    <property name="Jdlistid" column="JDLISTID" type="int" />
    <!--汽车管理ID-->
    <property name="Carinfoid" column="CARINFOID" type="int" />
    <!--车号-->
    <property name="Carno" column="CARNO" type="string" />
    <!--汽车司机-->
    <property name="Driver" column="DRIVER" type="string" />
    <!--汽车司机ID-->
    <property name="Driverid" column="DRIVERID" type="string" />
    <!--汽车司机电话-->
    <property name="Drivertel" column="DRIVERTEL" type="string" />
    <!--乘客-->
    <property name="Passengers" column="PASSENGERS" type="string" />
    <!--乘客ID-->
    <property name="Passengersid" column="PASSENGERSID" type="string" />
    <!--编号-->
    <property name="Serialnumber" column="SERIALNUMBER" type="int" />
    <!--作业前送地点-->
    <property name="Sendaddress" column="SENDADDRESS" type="string" />
    <!--作业后接地点-->
    <property name="Receiveaddress" column="RECEIVEADDRESS" type="string" />
    <!--出车时间-->
    <property name="Dispatchtime" column="DISPATCHTIME" type="DateTime" />
    <!--司机携带工具id-->
    <property name="DriverCarryToolId" column="DRIVERCARRYTOOLID" type="int" />
   
  </class>
</hibernate-mapping>

mysql的web.config配置参考：

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
    <!--用Log4Net记录NHibernate中执行的SQL语句及执行时间-->
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
  </configSections>
  <!--NHibernate配置-->
  <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>
      <!-- 版本改为 5-->
      <property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
      <!--使用什么数据库-->
      <property name="connection.connection_string">Server=127.0.0.1;Database=whtest;User ID=root;Password=123456</property>
      <!-- Data Source=FirstSample.sdf  改为Server= localhost；Database=mygamedb；user ID=root；Password=root -->
      <property name="show_sql">true</property>
      <!--不配置hbm2ddl会报列“ReservedWord”不属于表 ReservedWords的错误-->
      <property name="hbm2ddl.keywords">none</property>
      <!--加载映射-->
      <mapping assembly="wh.db.test.model"/>

    </session-factory>
  </hibernate-configuration>
  <!--log4net配置-->
  <log4net debug="true">
    <appender name="ErrorLog" type="log4net.Appender.RollingFileAppender">
      <param name="File" value="D:\\Services\\Logs\\Error\\" />
      <param name="AppendToFile" value="true" />
      <param name="RollingStyle" value="Date" />
      <param name="DatePattern" value="yyyyMM\\yyyy-MM-dd".log"" />
      <param name="StaticLogFileName" value="false" />
      <layout type="log4net.Layout.PatternLayout">
        <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
      </layout>
      <filter type="log4net.Filter.LevelRangeFilter">
        <!--只接受最小等级与最大等级之间的日志输出,其他的被过滤,这里接受WARN(警告),ERROR(错误),FATAL(致命)级别的输出-->
        <param name="LevelMin" value="WARN" />
        <param name="LevelMax" value="FATAL" />
      </filter>
    </appender>
    <root>
      <level value="ALL" />
      <appender-ref ref="ErrorLog" />
    </root>
  </log4net>
  <system.web>
    <compilation debug="true" targetFramework="4.0" />
    <!--需要配置该节点,不然HttpContext.current是为空的-->
    <httpModules>
      <add name="NHSessionFactory" type="wh.db.test.dao.DataBase.NHSessionFactory" />
    </httpModules>
  </system.web>
  <system.serviceModel>
    <behaviors>
      <serviceBehaviors>
        <behavior>
          <!-- 为避免泄漏元数据信息，请在部署前将以下值设置为 false 并删除上面的元数据终结点 -->
          <serviceMetadata httpGetEnabled="true"/>
          <!-- 要接收故障异常详细信息以进行调试，请将以下值设置为 true。在部署前设置为 false 以避免泄漏异常信息 -->
          <serviceDebug includeExceptionDetailInFaults="false"/>
        </behavior>
      </serviceBehaviors>
    </behaviors>
    <!--必须配置aspNetCompatibilityEnabled为true否则HttpContext.current为空-->
    <serviceHostingEnvironment multipleSiteBindingsEnabled="true" aspNetCompatibilityEnabled="true"/>
  </system.serviceModel>
  <system.webServer>
    <modules runAllManagedModulesForAllRequests="true"/>
  </system.webServer>

</configuration>

oracle的web.config参考：

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
    <!--用Log4Net记录NHibernate中执行的SQL语句及执行时间-->
    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
  </configSections>
  <appSettings file="Config/EPAPConfig.config">
    <add key="Epapid" value="025" />
    <add key ="WebUrl" value="http://192.168.1.161:1125"/>
  </appSettings>
  <!--nhibernate配置-->
  <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory name="ora10gFactory">
      <property name="dialect">NHibernate.Dialect.Oracle10gDialect</property>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider, NHibernate</property>
      <property name="connection.driver_class">NHibernate.Driver.OracleClientDriver</property>
      <!--<property name="connection.driver_class">NHibernate.Driver.OracleManagedDataClientDriver</property>-->
      <property name="connection.connection_string">
        <!--User Id=epapsz;Password=epapsz;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TMIS)))-->
      </property>
      <property name="adonet.batch_size">10</property>
      <property name="show_sql">false</property>
      <property name="command_timeout">60</property>
      <!--加载hibernate自动更新数据库结构，update为更新，none为不更新-->
      <property name="hbm2ddl.auto">none</property>
      <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
      <property name="proxyfactory.factory_class">NHibernate.Bytecode.DefaultProxyFactoryFactory,NHibernate</property>
      <property name="hbm2ddl.keywords">none</property>
      <property name="cache.provider_class">NHibernate.Cache.HashtableCacheProvider</property>
      <property name="cache.use_second_level_cache">false</property>
      <property name="cache.use_query_cache">false</property>

      <!--加载映射-->
      <mapping assembly="EPAP.SZ.Models" />
      <mapping assembly="EPAP.SZ.ViewModels" />
    </session-factory>
  </hibernate-configuration>
  <!--log4net配置-->
  <log4net debug="true">
    <appender name="ErrorLog" type="log4net.Appender.RollingFileAppender">
      <param name="File" value="D:\\Services\\Logs\\Error\\" />
      <param name="AppendToFile" value="true" />
      <param name="RollingStyle" value="Date" />
      <param name="DatePattern" value="yyyyMM\\yyyy-MM-dd".log"" />
      <param name="StaticLogFileName" value="false" />
      <layout type="log4net.Layout.PatternLayout">
        <param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
      </layout>
      <filter type="log4net.Filter.LevelRangeFilter">
        <!--只接受最小等级与最大等级之间的日志输出,其他的被过滤,这里接受WARN(警告),ERROR(错误),FATAL(致命)级别的输出-->
        <param name="LevelMin" value="WARN" />
        <param name="LevelMax" value="FATAL" />
      </filter>
    </appender>
    <root>
      <level value="ALL" />
      <appender-ref ref="ErrorLog" />
    </root>
  </log4net>
  <system.web>
    <compilation debug="true" targetFramework="4.0" />
    <httpModules>
      <add name="NHSessionFactory" type="EPAP.SZ.DAL.DataBase.NHSessionFactory" />
    </httpModules>
  </system.web>
  <system.serviceModel>
    <behaviors>
      <serviceBehaviors>
        <behavior>
          <!-- 为避免泄漏元数据信息，请在部署前将以下值设置为 false 并删除上面的元数据终结点 -->
          <serviceMetadata httpGetEnabled="true" />
          <!-- 要接收故障异常详细信息以进行调试，请将以下值设置为 true。在部署前设置为 false 以避免泄漏异常信息 -->
          <serviceDebug includeExceptionDetailInFaults="true" />
        </behavior>
      </serviceBehaviors>
    </behaviors>
    <!--管理会话状态-->
    <serviceHostingEnvironment multipleSiteBindingsEnabled="true" aspNetCompatibilityEnabled="true"/>
    <!--考勤一体机服务-->
    <bindings>
      <basicHttpBinding>
        <!--其实要修改所有的服务，不管是服务端还是客户端，Binding那边增加一个没有设置名字的默认配置就OK了 maxBufferSize="2147483647"-->
        <binding   closeTimeout="00:10:00" receiveTimeout="00:10:00" sendTimeout="00:10:00"
        maxReceivedMessageSize="2147483647" maxBufferSize="2147483647">
        </binding >
      </basicHttpBinding>
    </bindings>
    <!--考勤一体机服务end-->

  </system.serviceModel>
  <system.webServer>
    <modules runAllManagedModulesForAllRequests="true" />
    <validation validateIntegratedModeConfiguration="false" />
  </system.webServer>
</configuration>