Could not compile the mapping document: NHibernate

Question

I am completely new to NHibernate. I saw many questions with the same title but I am unable to find the exact error. I am using NHibernate with SQL Server 2012.

My hibernate.cfg.xml :

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
        <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
        <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
        <property name="dialect">NHibernate.Dialect.MsSql2012Dialect</property>
        <property name="connection.connection_string">Data Source=.\SQLEXPRESS;Initial Catalog=cafePOSdb;Integrated Security=True;</property>
        <property name="show_sql">true</property>
        <mapping assembly="CafePOS" />
    </session-factory>
</hibernate-configuration>

My mapping model:

using System;
using System.Text;
using System.Collections.Generic;

namespace CafePOS
{
    public class CafeTableGroup 
    {
        //properties here
    }
}

My hbm.xml file:

<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping assembly="CafePOS" namespace="CafePOS" xmlns="urn:nhibernate-mapping-2.2">
  <class name="cafe_table_group" table="cafe_table_group" lazy="true" >
   <!--properties here -->
  </class>
</hibernate-mapping>

My SessionFactory class:

namespace XXXXXX
{
    public sealed class SessionFactory
    {
        private static volatile ISessionFactory iSessionFactory;
        private static object syncRoot = new Object();
        public static ISession OpenSession
        {
            get
            {
                if (iSessionFactory == null)
                {
                    lock (syncRoot)
                    {
                        if (iSessionFactory == null)
                        {
                            Configuration configuration = new Configuration();
                         Assembly assembly = Assembly.GetCallingAssembly();
                             configuration.AddAssembly(assembly);
                           iSessionFactory = configuration.BuildSessionFactory();
                        }
                    }
                }
                return iSessionFactory.OpenSession();
            }
        }
    }
}

This is the function that I tried to implement:

public static string Add(CafeTableGroup group)
{
    using (ISession session = SessionFactory.OpenSession)
    {
        using (ITransaction transaction = session.BeginTransaction())
        {
            try
            {
                session.Save(group);
                transaction.Commit();
                return "1";
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                session.Close();
                throw ex.InnerException;
            }
        }
    }
}

I get error on the line

configuration.AddAssembly(assembly);

showing the error in the title:

Could not compile the mapping document: NHibernate

Inner exception message:

Could not find the dialect in the configuration

Thanks in advance.

score 1 · Accepted Answer · edited Aug 27 '17 at 11:25

1

Your class name is not cafe_table_group, but CafeTableGroup.

Can you try by changing your hbm.xml to

<class name="CafeTableGroup" table="cafe_table_group" lazy="true">
             **************

edited Aug 27 '17 at 11:25

marc_s

732,580
175
1,330
1,459

answered Aug 27 '17 at 11:20

HGMamaci

1,339
12
20

score 0 · Answer 2 · answered Aug 27 '17 at 11:08

0

You should have the file hibernate.cfg.xml in the root folder.

Sample content of the file is:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
        <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
        <property name="dialect">Netsis.Framework.Persister.Hibernate.Dialect.NMsSql2008Dialect, Netsis.Framework.Persister</property>
        <property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
        <property name="connection.connection_string">Data Source=localhost;Initial Catalog=CRM;Persist Security Info=True;User ID=user;Password=pass</property>
        <property name="proxyfactory.factory_class">Netsis.Framework.Persister.Hibernate.Proxy.PropertyReaderProxyFactoryFactory,Netsis.Framework.Persister</property>
        <property name="show_sql">True</property>
        <property name="format_sql">True</property>
        <property name="adonet.batch_size">30</property>  
    </session-factory>
</hibernate-configuration>

answered Aug 27 '17 at 11:08

HGMamaci

1,339
12
20

sir I am using Visual studio 2015 and hibernate.cfg.xml is in the same location as App.Config. – Dot Net developer Aug 27 '17 at 11:14
Ok - could not see your project files, so I suggested. I found another one. Posting another answer. Appreciate if you can confirm, if it works. – HGMamaci Aug 27 '17 at 11:20
sorry to say sir but that didn't work.I am stuck in it for a couple of hours.Please help me if you can – Dot Net developer Aug 27 '17 at 11:26
sir I have just now added inner exception message .Can you please look at it? – Dot Net developer Aug 27 '17 at 11:39
Sorry. I just saw your messages. Did my other answer solved your problem? Let me know if not. – HGMamaci Aug 28 '17 at 11:45
Please check this out for the dialect exception: https://stackoverflow.com/questions/4633459/nhibernate-how-to-solve-this-dialect-configuration-issue – HGMamaci Aug 28 '17 at 11:47
Thanks sir.The link you shared helped me. – Dot Net developer Aug 29 '17 at 04:32

Could not compile the mapping document: NHibernate

2 Answers2