Hi there,
I had the same problem before, did you add reference to the MySql.Data dll ? Make sure u go into the property of that reference and make copy local = "True". And about your dialect config, im not sure if this is going to solve it, but check out my config and see if u can use it this way:
Code:
<property name="hbm2ddl.keywords">none</property>
<property name="proxyfactory.factory_class">NHibernate.ByteCode.Castle.ProxyFactoryFactory, NHibernate.ByteCode.Castle</property>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
<property name="connection.connection_string">Server=localhost;Database=NGV;User ID=root;Password=root;CharSet=latin1</property>
[b]<property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>[/b]
Let me know if this works, im new to this too so it might not be the same issue, but I try to help!
Good luck
Vishan S Gill