I'm trying to generate SQL along the lines of:
SELECT
t.*,
SELECT (...)
FROM Title t
[trimmed]
using QueryOver
Title title = null;
var q = session
.QueryOver(() => title)
.Select(
Projections.Alias(Projections.Property<Title>(t => t.Id), "Id"),
Projections.Alias(Projections.Property<Title>(t => t.Name),
"Name"),
....
Projections.SubQuery(sq.Where(tt => tt.Id == title.Id))),
"TopLevelGenre")
)
[code trimmed]
There are 15 properties in Title that I would like to project. Is
there an easier way of doing it so that I don't have to project each
property individually as I've started to do above?
Thanks!
--
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.
