Hi,
I am using QueryOver to do some querying. However, I need to do some simple
arithmetic in my query (multiply two columns) and due to legacy constraints
and so on, I need to do this directly in my query and cannot simply add a
calculated column in the database.
Since QueryOver doesn't directly support these arithmetic operations, I am
using an SQLProjection. Currently it seems that the only alias that can be
used in an SQLProjection is "{alias}" which refers to the root table of the
criteria (typically "this_").
Now, because of some overlapping column names I would also like to be able
to specify the column names of joined tables. I have given the joined table
aliases which I can indeed use in the rest of my QueryOver, but the SQL
table aliases that are generated by NHibernate are decorated and truncated
so I cannot directly use my alias names in the projection (e.g. a table
"FooBarBazBoo" will become something like "foobarba3_".
Are there any plans to extend the alias support in SQLProjection to allow
the use of joined tables? If not, is this due to lack of time, or is it
simply by design (and I shouldn't bother trying to add this feature)?
Thanks,
Roy
--
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.
