I have a one-to-one or one-to-none situation with menu to protracforms. When I select the menu Object based on the MenuGroup I get the following SQL. It all looks good except for
NHibernate: SELECT this.ItemID as ItemID2_, this.Type as Type2_, this.SortOrder as SortOrder2_, this.MenuGroupID as MenuGrou2_2_, this.Description as Descript3_2_, this.ItemName as ItemName2_, menugroup1_.MenuGroupID as MenuGrou1_0_, menugroup1_.Description as Descript2_0_, protracfor2_.FormID as FormID1_, protracfor2_.FormName as FormName1_, protracfor2_.Category as Category1_ FROM ProTrac.dbo.Menu this left outer join ProTrac.dbo.MenuGroup menugroup1_ on this.MenuGroupID=menugroup1_.MenuGroupID left outer join ProTrac.dbo.Form protracfor2_ on
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="DTP.Data.Menu,DTP" table="Menu">
<id name="Id" column="ItemID" type="Int64" >
<generator class="native"/>
</id>
<many-to-one name="MenuGroup" column="MenuGroupID" class="DTP.Data.MenuGroup,DTP" />
<property column="Description" name="Description" not-null="true" length="50" />
<property column="SortOrder" name="SortOrder" />
<property column="Type" name="Type" not-null="true" length="50" />
<property column="ItemName" name="ItemName" length="50" />
<one-to-one name="ProTracForm" foreign-key="FormID" class="DTP.Data.ProTracForm,DTP" "/>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="DTP.Data.ProTracForm,DTP" table="Form">
<id name="Id" column="FormID" type="Int64">
<generator class="native"/>
</id>
<bag name="LabelFormList" inverse="true" lazy="true" >
<key column="FormID" />
<one-to-many class="DTP.Data.LabelForm,DTP" />
</bag>
<bag name="RoleFormList" inverse="true" lazy="true" >
<key column="FormID" />
<one-to-many class="DTP.Data.RoleForm,DTP" />
</bag>
<one-to-one name="Menu" class="DTP.Data.Menu,DTP" constrained="true" />
<property column="FormName" type="String" name="FormName" not-null="true" length="30" />
<property column="Category" type="Byte" name="Category" />
</class>
</hibernate-mapping>
public sealed class ProTracForm
{
…
private Menu m_menu;
…
public Menu Menu
{
get { return m_menu; }
set
{
m_isChanged |= (m_menu != value);
m_menu = value;
}
}
public override string ToString()
{
return m_formname;
}
…
}
public sealed class Menu : BaseObject
{
#region Private Members
private bool m_isChanged;
private ProTracForm m_form;
private MenuGroup m_menugroup;
private string m_description;
private int m_sortorder;
private string m_type;
private string m_itemname;
#endregion
#region Default ( Empty ) Class Constuctor
/// <summary>
/// default constructor
/// </summary>
public Menu()
{
}
#endregion // End of Default ( Empty ) Class Constuctor
#region Public Properties
/// <summary>
///
/// </summary>
public override long Id
{
get { return m_id; }
set { m_id = value; }
}
/// <summary>
///
/// </summary>
public MenuGroup MenuGroup
{
get { return m_menugroup; }
set
{
if (value == null)
throw new ArgumentOutOfRangeException("Null value not allowed for Group", value, "null");
m_isChanged |= (m_menugroup != value);
m_menugroup = value;
}
}
/// <summary>
///
/// </summary>
public ProTracForm ProTracForm
{
get { return m_form; }
set
{
m_isChanged |= (m_form != value);
m_form = value;
}
}
public bool IsChanged
{
get { return m_isChanged; }
}
#endregion
}
Login
FAQ
Search
