Hi,
I am new to nHibernate and i am facing some problem while accessing the application. I have downloaded the latest version of nHibernate. I am having the UserInfo as class and trying with SQL server as backend. Very simple class and .hbm.xml file. I have searched all the internet content and applied as per their suggestions. Still i am facing "Could not find the dialect in the configuration". Please suggest.

With Regards
Shyam Sundar R

Can you post your configuration file and the code where you build the session factory ?

This is my hibernate.cfg.xml file
<?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="hibernate.dialect">NHibernate.Dialect.MsSql2000Dialect</property>
<property name="connection.driver_class">NHibernate.Driver.SqlClientDriver</property>
<property name="connection.connection_string">Data Source=FirstSample.sdf</property>
<property name="show_sql">true</property>
</session-factory>
</hibernate-configuration>

I have single form with button, the following code snippet will be for button_Click

Configuration config = new Configuration().Configure();

config.AddAssembly((typeof(UserInfo).Assembly));

ISessionFactory sessionFactory = config.BuildSessionFactory();
ISession session = sessionFactory.OpenSession();
ITransaction transaction = session.BeginTransaction();

UserInfo currentUser = new UserInfo();
currentUser.Name = "Shyam Sundar";
currentUser.Password = "success";
currentUser.Email = "[email protected]";
currentUser.Company = "HCL";

session.Save(currentUser);
transaction.Commit();
session.Close();

This is my UserInfo.Hbm.xml file:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="HibernatorSample" namespace="HibernatorSample">
<class name="UserInfo" >
<id name="Id" column="LoginId">
<generator class="assigned" />
</id>
<property name="Name" column="Name" type="String" length="50"/>
<property name="Password" type="String" length="20"/>
<property name="Email" column="Email" type="String" length="50"/>
<property name="Company" column="Company" type="String" length="50"/>
</class>
</hibernate-mapping>

I have created the table in local sql server. I have tried with various ways. Please suggest me a link, i need to run a sample application with nHibernate. Thanks for your help
Shyamdvk

Is your hibernate.cfg.xml marked as "Embedded Resource" ?

Yes it Embeded only..I have checked once again. Is there anything do i need to change in the code? or give me the sampel file location so that i can download and start loot at the action. Your reple is appreciated

Shyamdvk

Which hibernate version are you using ? If it's 2.0 you don't need "hibernate." for the properties anymore:

<property name="dialect">...</property>

Latest one i am using.

Shyamdvk

So does it work if you remove "hibernate." from your dialect configuration ?

Sorry to say, i am facing the same problem

Shyamdvk

Hi,
Thanks for your effort. I have downloaded the new sample from http://www.hibernate.org/379.html and configured my database too. Program complied without any error. While running i have received the following error
"The type initializer for 'OrderSystem.UI.NHibernateSessionFactory' threw an exception."
and the inner Exception says that

Could not compile the mapping document: OrderSystem.Objects.Mappings.Product.hbm.xml"

and

InnerException
{"There is an error in XML document (1, 2)."}

I have not altered anything in the code. What could be the reason for this error. Where i need to change in the code, anything that i have missed? Just curious. Need your assistance in this please

Shyamdvk

That's probably an old example which still uses a version < 1.2 (where the xml namespace has been changed). Go back to your own example and try to set the build action to "None" and copy to output directory to "Copy Always". I'm always mixing that up with the config files.