Excellent job.
Please include schema name to generated mapping file like this:
<?xml version=\"1.0\" encoding=\"utf-8\" ?>
- <hibernate-mapping xmlns=\"urn:nhibernate-mapping-2.2\">
- <!-- Build: with
lujan99@usa.net Nhibernate template
-->
- <class name=\"ProductCatalog.BusinessObject.Category,ProductCatalog.BusinessObject\" table=\"Category\" lazy=\"true\" schema=\"Production\">
- <id name=\"Categoryid\" column=\"CategoryID\" type=\"int\">
<generator class=\"native\" />
</id>
<many-to-one name=\"CategoryMember\" column=\"ParentCategoryID\" cascade=\"save-update\" />
- <bag name=\"CategoryDescription\" inverse=\"true\" lazy=\"true\" cascade=\"delete\">
<key column=\"CategoryID\" />
<one-to-many class=\"ProductCatalog.BusinessObject.CategoryDescription,ProductCatalog.BusinessObject\" />
</bag>
- <bag name=\"CategoryProperty\" inverse=\"true\" lazy=\"true\" cascade=\"delete\">
<key column=\"CategoryID\" />
<one-to-many class=\"ProductCatalog.BusinessObject.CategoryProperty,ProductCatalog.BusinessObject\" />
</bag>
- <bag name=\"Product\" inverse=\"true\" lazy=\"true\" cascade=\"delete\">
<key column=\"CategoryID\" />
<one-to-many class=\"ProductCatalog.BusinessObject.Product,ProductCatalog.BusinessObject\" />
</bag>
</class>
</hibernate-mapping>
Thanks