Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Session.CreateCriteria ( typeof ( Order ) )
- .Add ( Restrictions.Between ( "DateReceived" , today.AddMonths ( -1 ) , today ) )
- .CreateAlias ( "Lines" , "lines" )
- .SetProjection (
- Projections.ProjectionList ( )
- .Add ( Projections.Sum ( "lines.TotalCost" ) )
- .Add ( Projections.Avg ( "lines.TotalCost" ) )
- .Add ( Projections.GroupProperty ( "Customer" ) )
- ) ;
Add Comment
Please, Sign In to add comment