Latest posts for the topic "ORM Code on ASP.NET and SQL Server 2005"

ORM Code on ASP.NET and SQL Server 2005

Eduardo — Tue, 17 Apr 2007 01:12:46

Hi, I am using ORM code in an ASP.NET application (it's a web service) and my code runs perfectly in a console application but crashs in the Web Service.
The message is

Code:

 NHibernate.HibernateException: The dialect was not set. Set the property hibernate.dialect.
    on NHibernate.Dialect.Dialect.GetDialect()
    on NHibernate.Dialect.Dialect.GetDialect(IDictionary props)
    on Orm.PersistentManager.ResolveNativeIDGenerators()
    on Orm.PersistentManager..ctor(DotNetConnectionSetting connectionSetting, SessionType sessionType)
    on Persistencia.EvalModelSystemOrmPersistentManager..ctor()
    on Persistencia.EvalModelSystemOrmPersistentManager.Instance()
    on Persistencia.ModeloFactory.LoadModeloByORMID(Int32 ID)
    on EvalModelService.CrearModeloPrueba() en d:\Visual Studio 2005\Projects\EvalModelProject\EvalModelWebService\App_Code\EvalModelService.cs:línea 63

and the simple code:

Code:

       try
         {
             bool aux = modelo.Save();            
         }
         catch (Exception ex)
         {
             ex.ToString();
         }

Re:ORM Code on ASP.NET and SQL Server 2005

Jick — Tue, 17 Apr 2007 13:20:36

Hello Eduardo,

To solve the problem, please embed hibernate.cfg.xml in the assembly.

Best regards,
Jick

Re:ORM Code on ASP.NET and SQL Server 2005

Eduardo — Tue, 17 Apr 2007 17:16:25

THANNNKKKKK YOUUUUUUUUUUU!!!!!
The problem is solved!! :D

Thanks!

Re:ORM Code on ASP.NET and SQL Server 2005

Anonymous — Tue, 1 May 2007 01:10:57

Please could you help me with a similar problem.

I have a file called NHibernate.xml which I assume is the cfg file to which you refer. How do I ' embed hibernate.cfg.xml in the assembly'.

Currently I get I get........

Server Error in '/VSC' Application.
--------------------------------------------------------------------------------

The dialect was not set. Set the property hibernate.dialect.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: NHibernate.HibernateException: The dialect was not set. Set the property hibernate.dialect.

Source Error:

etc etc................

Re:ORM Code on ASP.NET and SQL Server 2005

Eduardo — Tue, 1 May 2007 01:33:20

OK!!

1º) Add an existing item... the file "hibernate.cfg.xml" to your project.

2º) Click right button over the item "hibernate.cfg.xml" in the tree project.

3º) Select "Properties"

4º) And select "Embeded resource" in "Action generation".

5º) You can compile your project and add the .dll file to another project.

(Sorry for my english)