I'm defining a named query to load a class that has IDictionary
member. What is the syntax in the SQL for loading the IDictionary. The
class and mapping document are below.
class CultureResources
int Id
IDictionary ResourceSet
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="XXX.Infrastructure"
namespace="XXX.Infrastructure.Localization"
default-access="nosetter.pascalcase-underscore"
default-lazy="false">
<sql-query name="FindCultureResourcesByType">
<query-param name="ApplicationName" type="String"/>
<query-param name="ResourceType" type="String"/>
<query-param name="CultureCode" type="String"/>
<return alias="Resources" class="CultureResources"/>
<return-join alias="Values" property="Resources.ResourceSet"/>
<![CDATA[
//QUESTION : What's the syntax to map to the dictionary
Resources.ResourceSet
SELECT ct.Id AS {Resources.Id}
FROM CultureResourceValues cv
INNER JOIN CultureResourceSets cs ON cs.CultureResourceValueId =
cv.Id
INNER JOIN CultureResourceTypes ct ON ct.Id =
cs.CultureResourceTypeId
INNER JOIN Applications a ON a.Id = ct.ApplicationId
WHERE a.ApplicationName = :ApplicationName AND
ct.ResourceType = :ResourceType AND
ct.CultureCodeId = :CultureCode
]]>
</sql-query>
</hibernate-mapping>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
