typed datasets and duplicated relations

[Iain]

I'm struggling to create a typed data set (with xsd.exe) with 4 tables and 3
layers

orders -> Items
Items->ItemAtts1
Items->ItemAtts2

if you follow me. it's kind of working, but I don't seem to be getting the
bottom relationship (Items->ItemAtts2). When I look in the generated code I
find that each (foreign) key and each relationship *appears* to be
duplicated.

Basically the information is the same but the names are different
Orders_Items and ItemsInOrder and the column names are like OrderID and
OrderID_0.

I found that I was getting duplicate definitions (in the class definitions)
when I used the typedChildren annotation in the keyrefs and I wonder if this
relates.

Any ideas?

Iain

[Iain]

Well, I've removed *all* the annotations and that seems to have made things
work. I still seem to have a choice of 2 relations (GetOrder_Items or
GetItemsInOrder) but I no longer have duplicate definitions in the generated
CS.

My key and key refs were made by VS in the XSD editor.

Why are these duplications happening and why do annotations screw things up?
Iain
"Iain" <id********@dircon.co.uk> wrote in message
news:ub**************@TK2MSFTNGP10.phx.gbl...

I'm struggling to create a typed data set (with xsd.exe) with 4 tables and 3 layers

orders -> Items
Items->ItemAtts1
Items->ItemAtts2

if you follow me. it's kind of working, but I don't seem to be getting the bottom relationship (Items->ItemAtts2). When I look in the generated code I find that each (foreign) key and each relationship *appears* to be
duplicated.

Basically the information is the same but the names are different
Orders_Items and ItemsInOrder and the column names are like OrderID and
OrderID_0.

I found that I was getting duplicate definitions (in the class definitions) when I used the typedChildren annotation in the keyrefs and I wonder if this relates.

Any ideas?

Iain