Hi,
I have a class which is as follows
Class SearchFilter
Public Property SearchFilterID As Integer
Public Property SearchFilterName As String
...
End Class
Public Class SearchFilterCount
Public Property SearchFilterCountID As Integer
Public Property SearchFilter As SearchFilter
Public Property ItemCount As Integer
End Class
I am trying to return a SearchFilterCount object from a ICriteria
query as follows (removed some details for clarity)
qry.CreateAlias("SearchFilter", "sf",
SqlCommand.JoinType.InnerJoin) _
.SetProjection(Projections.ProjectionList() _
.Add(Projections.GroupProperty
("sf.SearchFilterID"), "SearchFilterID") _
.Add(Projections.GroupProperty
("sf.SearchFilterName"), "SearchFilterName") _
.Add(Projections.GroupProperty
("sf.SearchGroup"), "SearchGroup") _
.Add(Projections.GroupProperty
("sf.DisplayOrder"), "DisplayOrder") _
.Add(Projections.CountDistinct
("Contract.ContractID"), "ItemCount")) _
.SetResultTransformer
(Transformers.AliasToBean(GetType(SearchFilterCount)))
The sql is produced correctly but the AliasToBean method cannot map
the SearchFilterCount object. I get the following error
"Could not find a setter for property 'SearchFilterID' in class
'SearchFilterCount'"
I've tried prefixing the projected values with the name of the nested
class, i.e.
.Add(Projections.GroupProperty("sf.SearchFilterID"),
"SearchFilter.SearchFilterID") _
but that didn't work either.
Is there a way to do this?
Thanks
James
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
