R – NHibernate: Criteria Issue with parameter type

criterianhibernate

I have a varchar field in a table, mapped to string property on a class. Pretty simple stuff, however when I create a criteria to retieve enities based on this field, NHibernare is generating invalid sql. The where clause looks like "Where accountnum = 120001", which won't work with a varchar obviously. Any ideas?

Best Answer

NHibernate should be generating a parameterized statement ... something like "Where accountnum = @p1". If it is not, then something is configured wrong.

Related Solutions

R – Nhibernate Tag Cloud Query

I managed to get it working like this :

var dc = DetachedCriteria.For<Foo>( "f")
            .CreateCriteria("Tags", "t")
            .Add(Restrictions.InG("t.Id", idsIn))
            .SetProjection(Projections.SqlGroupProjection("{alias}.FooId", "{alias}.FooId having count(distinct t1_.TagId) = " + idsIn.Count,
                         new[] { "Id" }, 
                           new IType[] { NHibernateUtil.Int32 }));

The only problem here is the count(t1_.TagId) - but I think that the alias should be generated the same every time in this DetachedCriteria - so you should be on the safe side hard coding that.

Best Answer

Related Solutions

R – Nhibernate Tag Cloud Query

Related Topic