Where clause in nhibernate map

Question

I have an Nhibernate hbm that maps a many to many relationship. For database simplicity it uses a where clause on the bag to filter the joining table.

this works well until I start to test and I use the hbm file to create a database from the generated schema. The root and user tags columns aren't created.

In the hbm file how do I define these two columns so they are generated in the schema?

Answer 1

this works for me (sorry if you don't like attribute mapping - but I think you should get the idea). Important is specifying both columns - otherwise it included a strange column (val - something along the line - forgot the exact name) and used this instead of the ones I wanted.

[Bag(0, Cascade = "all", Table = "item_hierarchy")]
[Key(1, Column = "child")]
[ManyToMany(2, ClassType = typeof(Item), Column="parent",NotFound = NotFoundMode.Ignore)]
public virtual IList<Item> Parent { get; set; }