Hi,

I have been working through the tutorial here: http://nhforge.org/wikis/howtonh/your-f ... ation.aspx (Your first NHibernate based application)

All is going fairly well. I can watch the results of what I'm doing via log4net, NUnit, and nhprof. The nhibernate code appears to be executing the generated sql.

So, nunit tells me that the system is executing:



I then see the query appear in nhprof.

But, no change is made to the database.

Same for inserts.

I see no errors at all.

I can make changes to the database manually.

If you want to know my setup just take a look at the tutorial. I have followed each of the steps.
Anyway, it's windows 2008, sql server compact, .net 4.0, visual studio 2010 etc...

What could be going on? Given that I've looked at all sorts of logging output and it all seems fine, I'm stumped.

Let me know what information you'd like me to post in order to answer this.

Many thanks!

Hrm...

I switched the connection over to a full mssql engine, instead of the compact engine.

And now it works.

Perhaps the dialect was wrong for the compact edition... checking...

Nope, the compact edition does not like the 2005 dialect.

So, I don't know why the compact edition wasn't storing any of the query results, but I do have nhibernate working now with the full 2008 engine.

In any case, if anyone has insights on why it wouldn't have worked with the compact edition then please let me know.

Thanks.