Is it possible to do math in a detached criteria?

Something like this?

DetachedCriteria mv = DetachedCriteria.For<Asset>()
.Add(Subqueries.PropertyIn("ID", assetIDCriteria))
.CreateAlias("Security", "security")
.SetProjection("security.Price * Asset.Balance");

Obviously the project here does not work but I am looking for the equivalent from a detached criteria. We do a lot of custom list filtering so it would very difficult to write hql.

You can project direct sql in a criteria:

crit.SetProjection( Projections.SqlProjection( ) )


If that's what you're looking for.

Isnt SqlProjection dbms specific? I am trying to remain vendor agnostic.

I assume that depends on your sql. If you do simple arithmetic, it should be possible to do that vendor independant. Another approach might be computed properties.