Re: How to use external Dialec of NHibernate with gernated code

Hello my friends,

I'm doing a test on NHibernate with PostgreSQL + PostGIS db.

All reference is added, but there is an error: Dialec couln't load. The dialec is NHibernate.Spatial.Dialect.PostGisDialect as information at this article. This dialec is in the external dll: NHibernate.Spatial.PostGis.dll. Here is introduction information:

How can I configure to make this external dialec working with NHibernate?

My App.config is below:

--------------------------------------------------------------------

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate"/>
  </configSections>
  <hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
    <session-factory>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="dialect">NHibernate.Spatial.Dialect.PostGisDialect,NHibernate.Spatial.PostGis</property>
      <property name="connection.driver_class">NHibernate.Driver.NpgsqlDriver</property>
      <property name="connection.connection_string">Server=127.0.0.1;Port=5432;Database=demogis;User Id=postgres;Password=mypassword;Preload Reader = true;</property>

      <!-- NHibernate 2.1 -->
      <property name="proxyfactory.factory_class">NHibernate.ByteCode.LinFu.ProxyFactoryFactory, NHibernate.ByteCode.LinFu</property>

      <mapping assembly="DemoGISData"/>
    </session-factory>
  </hibernate-configuration>
<startup><supportedRuntime version="v2.0.50727"/></startup></configuration>

--------------------------------------------------------------------