Hello,
I'm loading a DTO who's properties are mapped on the tables' columns
and one property is calculated from the others.
with SQL:
SELECT
ud.DateOfReading
, ud.IdleTime
, ud.SavingsTime
, ud.SaveSetting
, (ud.SavingsTime * ud.SaveSetting/ud.IdleTime * 0.7) as SaveScore
is it possible to define that formula in the ICriteria's projections?
with ICriteria:
.SetProjection( Projections.ProjectionList()
.Add( Projections.Property( "DateOfReading" ), "DateOfReading" )
.Add( Projections.Property( "IdleTime" ), "IdleTime" )
.Add( Projections.Property( "SavingsTime" ), "SavingsTime" )
.Add( Projections.Property( "SaveSetting" ), "SaveSetting" )
)
// set the transformer
.SetResultTransformer( Transformers.AliasToBean( typeof( SaveScoreDTO )
) )
.List<SaveScoreDTO>();
I know that I could calculate the SaveScore in the DTO, but I thought
I'd let the SQL server do it.
Thank you,
Daniel
--
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.
