Hello,
I use a really simple mapping to test many-to-one on the one side and
one-to-many on the other side associations. I use hbm2ddl to generate
the postgresql database, but i think there is something wrong.
In this example i use items and put them into categories. This is my
mapping an cs:
Item.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-
cascade="all">
<class name="WpfApplication1.Item, WpfApplication1">
<id name="id" access="field">
<generator class="native" />
</id>
<property name="Name" />
<many-to-one name="Category" />
</class>
</hibernate-mapping>
Category.hbm.xml
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-
cascade="all">
<class name="WpfApplication1.Category, WpfApplication1">
<id name="Id">
<generator class="native" />
</id>
<property name="Name" />
<list name="Items">
<key/>
<index/>
<one-to-many class="WpfApplication1.Item, WpfApplication1"/>
</list>
</class>
</hibernate-mapping>
Item.cs
public class Item {
private int id;
private IList<String> tags = new List<String>();
public virtual String Name { get; set; }
public Category Category { get; set; }
}
Category.cs
public class Category {
public IList items = new List<Item>();
public virtual String Name { get; set; }
public virtual int Id { get; private set; }
public virtual IList Items {
get { return items; }
set { items = value; }
}
public void AddItem(Item i) {
i.Category = this;
items.Add(i);
}
}
This results in the following database structure:
CREATE TABLE category (
id serial NOT NULL,
"name" character varying(255),
CONSTRAINT category_pkey PRIMARY KEY (id)
)
CREATE TABLE item (
id serial NOT NULL,
"name" character varying(255),
category integer,
idx integer,
CONSTRAINT item_pkey PRIMARY KEY (id),
CONSTRAINT fk742dc1781c9215d5 FOREIGN KEY (category)
REFERENCES category (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk742dc178d73c8956 FOREIGN KEY (id)
REFERENCES category (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
I don't understand why there is the second FK (fk742dc178d73c8956).
And it fails if you want to add a second item to a cetegory.
Are I'm doing anything wrong? I could send you a working vs projekt if
you wish.
Thank you,
Patrick
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
