Hello ,
I have 2 tables Category & Product .
tblCategory : tblProduct
CategoryId (PK) ProductId (PK)
CategoryName ProductName
CategoryId (FK)
Now i have problem in mapping with Product Table I don't know how to map
CategoryId of product table. I done something but its not working
Products.hbm.xml file
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
namespace="Test_NHibernate_Join_Tables"
assembly="Test_NHibernate_Join_Tables"
>
<class name="Test_NHibernate_Join_Tables.Products" table="tblProducts">
<id name="ProductId" type="int">
<generator class="native"/>
</id>
<property type="string" name="ProductName" >
<column name="ProductName"></column>
</property>
<set name="Category" inverse="true" cascade="all" >
<key column="CategoryId" />
<one-to-many class="Test_NHibernate_Join_Tables.Products"/>
</set>
</class>
</hibernate-mapping>
And my Product.cs File is
public class Products
{
public virtual int? ProductId { get; set; }
Category _category;
public virtual Category Category
{
get
{
return _category;
}
set
{
_category = value;
}
}
public virtual string ProductName { get; set; }
}
Thanks & Regards
Shwetamber