Hi

I have a problem with creating C# objects and then mapping them for the following database structure:

TABLE "OBJECT"
ID (PK) Int;
NAME varchar(50);

TABLE "PROPERTY"
ID (PK) Int;
NAME varchar(50);

TABLE "VALUES"
OBJECT_ID(PK) int;
PROPERTY_ID(PK) Int;
VALUE string;

I have read NHibernate manuals, but all of the examples for many to many mapping are without value column in VALUES table.

I'm using NHibernate 1.2 Beta 2 if this is important.

Thanks for the help in advance.

Hi,

Actually, I don't see a many-to-many structure here. To me, it's a:
one-to-many from object to value
and a
one-to-many from property to value

'value' should be an object in itself an cannot act as a many-to-many relation. Instead, use 2 one-to-many's.
Which means there's no direct link between "object" and "property": if you want to know which properties are bound to "object", you'll have to enumerate the value-objects.

Please rate this post if it helped,
X

Thanks. I will give it a try.
Anyway, if someone knows better solution to the problem I will be glad to share it.