Hello!

I've recently run into a very strange problem.
I've mapped a scalar-valued function like so:

<property name="propertiesName" formula="dbo.get_SomeFloatValue(some_id)"/>

When I do a query which filters by this property, the resulting SQL-select takes awfully long to return (tracked this by measuring the time it takes from handing control to NHibernate to the point where my program regains control).
When I copy/paste the exact same query from my output in VS to Management Studio, I get the results in next to no-time.

As far as I can see, I have no further options to track down the cause of this behaviour, so I have to ask, if I used NHibernate in an unappropriate way by doing this, or if there is anything I can do to improve performance here.


Any help would be much appreciated,
thanks in advance,
have a nice day!

Benjamin