NHibernate:如何解决这个“方言"配置问题 [英] NHibernate: How to solve this "dialect" configuration issue

问题描述

遇到问题

在运行时，我总是得到以下NHibernate.MappingException:

At runtime, I always get the following NHibernate.MappingException:

"Could not compile the mapping document: GI.InventoryManager.CYB.Mappings.Part.hbm.xml"

是的，它的构建操作设置为Embedded Resource.InnerException 说:

Yes, its build action is set to Embedded Resource. The InnerException says:

"Could not find the dialect in the configuration"

必填信息

这是我名为 hibernate.cfg.xml 的配置文件:

Here is my configuration file named hibernate.cfg.xml:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration  xmlns="urn:nhibernate-configuration-2.2" >
  <session-factory>
    <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
    <property name="connection.connection_string">
        Server=(local);initial catalog=GI_IM_CYB;Integrated Security=SSPI
    </property>
    <property name="adonet.batch_size">10</property>
    <property name="show_sql">false</property>
    <property name="dialect">NHibernate.Dialect.MsSql2005Dialect</property>
    <property name="use_outer_join">true</property>
    <property name="command_timeout">60</property>
    <property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
    <property name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory,     NHibernate.ByteCode.Castle</property>
  </session-factory>
</hibernate-configuration>

实际上是从 Configuration_Templates 文件夹中复制粘贴的，我只更改了以下信息:

Which actually is a copy-paste from the Configuration_Templates folder in which I only changed the following information:

Session Factory: "Removed the NHibernate.Test namespace and let the property for itself"
Dialect: "From MsSql2000Dialect To MsSql2005Dialect"
Connection_String: "I changed the Initial Catalog attribute to input my own database name"
Factory Class: "From LinFu to Castle"

这是我在代码中使用它的方式:

And here's how I'm using it in my code:

private void configBackgroundWorker_DoWork(object sender, DoWorkEventArgs e) {
    Configuration c = new Configuration();
    c.AddAssembly(typeof(Part).Assembly);
    lock (_sessionFactory) {
        _sessionFactory = c.BuildSessionFactory();
    }
}

可选信息

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" auto-import="true" assembly="GI.InventoryManager.CYB" namespace="GI.InventoryManager.CYB.Types">
  <class name="Part" table="Parts" lazy="true">
    <id name="Id" column="part_id">
      <generator class="native"/>
    </id>
    <properties name="Description"/>
    <properties name="Number"/>
    <properties name="InStockQty"/>
    <properties name="Cost"/>
  </class>
</hibernate-mapping>


public class Part {
    #region Private Members

    private string _description;
    private string _number;

    #endregion
    #region Constructors

    /// <summary>
    /// Initializes an instance of the GI.InventoryManager.CYB.Types.Part class.
    /// </summary>
    public Part() { }

    #endregion
    #region Properties

    /// <summary>
    /// Gets or sets the description of this part.
    /// </summary>
    public virtual string Description {
        get {
            return _description;
        } set {
            if (!string.IsNullOrWhiteSpace(value))
                _description = value.Trim();
        }
    }

    /// <summary>
    /// Gets the underlying datastore unique identifier.
    /// </summary>
    public virtual int Id { get; private set; }

    /// <summary>
    /// Gets or sets the user-defined number.
    /// </summary>
    public virtual string Number {
        get {
            return _number;
        } set {
            if (!string.IsNullOrWhiteSpace(value))
                _number = value.Trim();
        }
    }

    /// <summary>
    /// Gets or sets the in-stock quantity.
    /// </summary>
    public virtual int InStockQty { get; set; }

    /// <summary>
    /// Gets or sets the cost.
    /// </summary>
    public virtual double? Cost { get; set; }

    /// <summary>
    /// Gets the inventory value for this part.
    /// </summary>
    /// <remarks>
    /// <para>
    /// This read-only property returns the product of <see cref="T:InStockQty"/> and <see   cref="Cost"/>. 
    /// In case the <b>Cost</b> property does not have a value, zero is returned.
    /// </para>
    /// </remarks>
    public double InventoryValue {
        get {
            if (Cost.HasValue)
                return InStockQty * Cost.Value;
            return 0.0;
        }
    }

    #endregion
    #region Methods



    #endregion
}

环境

1. Windows 7 专业版；
2. Visual Studio 2010，面向 .NET 4.0；
3. NHibernate 3.0.0.GA；
4. SQL Server 2005.

问题

我已经尝试过将方言属性放在配置行上，但没有奏效.

I have already tried to put the dialect property on the line of the configuration, and it neither worked.

如何解决我遇到的这个方言问题?

How to solve this dialect problem that I have?

推荐答案

我觉得还行...你有没有看到这些相关的问题:

Looks allright to me ... have you seen these related questions:

• nhibernate-could-not-find-oracle-dialect-in-configuration 解决方法:在添加映射文档前调用configuration.Configure()

• nhibernate-could-not-find-oracle-dialect-in-configuration solution: call configuration.Configure() before adding the mapping document

nhibernate-and-sqlite-could-not-compile-the-mapping-document 解决办法:将hibernate.cfg.xml复制到输出目录

nhibernate-and-sqlite-could-not-compile-the-mapping-document solution: copy the hibernate.cfg.xml to the output directory

这些很容易犯的错误可能会引发给定的异常.

These are easy mistakes to make that can raise the given exception.

这篇关于NHibernate:如何解决这个“方言"配置问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！