When I want to query for an object based on the value of a property. I do something like,

ICriteria Query = Session.CreateCriteria(GetType(Customer))

Query.Add(New Expression.LikeExpression("LastName", "Doe")

Return Query.List(Of Customer)()

I'm running SQL Server 2000 and would like to leverage the full-text indexes I have setup which requires me to use the t-SQL Contains function. Suggestions?

Cheers,
Aeden

Hi Aeden,

You can add an arbitrary SQL expressions using:


Bear in mind that the SQL expression needs the column names as they appear in the database - not the object property names.

Does that help?

Regards,
Richard

That helps a little. There's no class called Expression.Sql, but I do see one name Expression.SqlCriterion.

Any ideas on the slightly more complicated situation where I want all orders placed by a customer with the last name of Doe. Usually I would do something like,

ICriteria Query = Session.CreateCriteria(GetType(Order))

Query.Add(New Expression.LikeExpression("Customer.LastName", "Doe")

Return Query.List(Of Order)()

Cheers,
Aeden

Hi Aeden,

The syntax for Expression.Sql is not a class ... it's a factory method that creates an ICriterion for you (making the interface more fluent).

There are two ways you can create the criteria you are talking about. Either using aliases:


Or using a second ICriteria:


Regards,
Richard