HI everybody!!!!
I have a table that I call Explanation that has a one to many relation with another called Problem. I'm trying to select any Explanation that has an specific charasteristic, using something like this:

ArrayList results = null ;

NHibernateUtil.beginTransaction();// Stating a transaction
results = (ArrayList)NHibernateUtil.getSession()
.CreateCriteria(typeof(Explanation))
.Add(Example.Create(ob).IgnoreCase())
.List();

And when I use the parameter ob to pass an Explanation I had created with an specific Problem and it does'nt return anything.
I don't know if is a trouble with the nhibernate mapping or something else.
help please

I suggest watching the sql being generated (either with log4net or event with kind of sql profiler)

Post the sql here if it after that still having a problem.

Could you please tell how to do that???

does your Example.Create have
a transaction in it, that actually commits the data?

You can turn on the flag show-sql="true" in your hibernate config or properties file.

log4net: http://hibernate.org/364.html

But if you are using MS Sql Server there is simple method which I personally prefer for quick watch - just use Sql Server Profiler tool.
For alternative databases, I'm sure there are simmillar tools.

I strongly suggest having sql-watch feature on the hand, without it spotting the problem can be real pain ;)