SqlRestriction where is it?

[MattO]

In NHibernate we are suppose to use the Restrictions class because the
Expressions class is "semi-depricated". However the Restrictions
class does not have a .Sql or .sqlRestriction (java has this).

What am I missing? How do you do a Sql string restriction with the
Restrictions class?

[Jason Meckley]

you could try SqlRestrictions.Whatever, but really why would you mix an object query with a sql query. if you need sql drop to session.createsqlquery("select * from table where...")

[MattO]

I actually figured it out and I didn't have to use a expression for
dynamic where clause. I'm dealing with legacy database and there are
some problems with it that do not map well to criteria class...

I couldn't find the SqlRestrictions class, where is it located? The
only thing I've found so far is Expression.Sql() and SqlProjection().

[Jason Meckley]

probably doesn't exist then. I was referring to it as something to try. Glad to hear you got it working!

[Marios Skounakis]

Restrictions can be defined not only on a property but also on a projection. And you can use SqlProjection inside a restriction.

So, instead of
q.Add(Expression.Sql("abs(some_numeric_field) > 0"))
you can do
q.Add(Restrictions.Gt(Projections.Sql("abs(some_numeric_field)", <insert rest of parameters for Sql Projection as needed>), 0))

--
You received this message because you are subscribed to the Google Groups "nhusers" group.

To post to this group, send email to nhu...@googlegroups.com.
To unsubscribe from this group, send email to nhusers+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.