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=</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=""--> <binding closeTimeout="00:10:00" receiveTimeout="00:10:00" sendTimeout="00:10:00" maxReceivedMessageSize="" maxBufferSize=""> </binding > </basicHttpBinding> </bindings> <!--考勤一体机服务end--> </system.serviceModel> <system.webServer> <modules runAllManagedModulesForAllRequests="true" /> <validation validateIntegratedModeConfiguration="false" /> </system.webServer> </configuration>