Use HQL instead.
Diego
On Wed, Sep 15, 2010 at 06:40, grae123 <[email protected]> wrote:
> Hi,
>
> I'm trying to run a query which will select 'propertya - propertyb'
> and must be having a bad day as I can't get it to work (NH3.0 alpha 3,
> QueryOver API)
>
> So-far I've tried:
>
> Doing a .Select(o => o.propertya - o.propertyb) but queryover expects
> the expression to be a property.
> Mapping a formula on my entity to the expression. Problem is propertyb
> is on a base-class and I can't get the formula to take that into
> account when producing sql.
> Doing a .SqlProjection which gets closer but the code is pretty gross
> and I couldn't help but think there must be an easier way.
>
> Has anyone done this using the Criteria API, and if-so how did you do
> it? Apologies if it's really simple (and it feels like it should be),
> but I've googled a fair bit and have not come up with any examples.
>
> Thanks,
>
> Graeme
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
