I have read some post about fetch=join - http://nhforge.org/blogs/nhibernate/archive/2009/04/09/nhibernate-mapping-lt-many-to-one-gt.aspx (ser4ik.livejournal.com/2505.html) So I have some question, Forexample I have class

<class name="AttributesInf" table="attr_inf">      
 <id name="Id">
   <generator class="identity"/>
 </id>
 <property name="Name" />
    <property name="Desc"/>
</class> 

以及

<class name="AttributeValue" table="attr_val">      
 <id name="Id">
   <generator class="identity"/>
 </id>
 <property name="Value" />
 <many-to-one name="AttrName" column="attrId"/>
</class> 

如果我使用这一地图时没有打上“灰色”,我就拿到了q子。

Select av.Id, av.Value, av.attrId From attr_val av where av.Id=...()

以及 after then separate sql queries like:

Select * From attr_inf where Id = av.attrId

因此,我 :

class AttrinuteInf 
{ 
int Id; 
string Name; 
string Desc; 
} 
class AttributeValue 
{ 
int Id; 
string  Value; 
AttributeInf AttrName;
}

如果我打上了fetch=“join”,我就有一个问题:

Select u.Id, u.UserName, u.BlogId, b.Id, b.BlogName, b.BlogAuthor, b.BlogMsg 
from Users u
Left outer join Blogs b 
On u.BlogId=b.Id
Where u.Id = ...

因此,我期望获得一个等级:

class AttributeValue
{
int Id;
string  Value;
string Name;
string Desc;
}

但是,我的结果与我没有确定“参与”的理由相同。

Is this all right? Are there any way to get properties from class maped as <many-to-one> directly? (not as AttrName.Name, but simply Name )

解释:

Part of mapping set above don t show my real problem. I want to map some entity as IDictionary<string,AttributeValue>. I map it as

<map name="Attributes" table="attr_val" lazy="true" cascade="all-delete-orphan" inverse="true">
<key column="item_id"></key>
<index column="name"></index> //I don t have that item in class AttributeValue, that is why I try to get it from other table
<one-to-many class="AttributeValue"/>
</map>