dotnet xml: typed datasets and duplicated relations -- dotnet xml

typed datasets and duplicated relations

Iain
12/29/2003 9:16:59 PM

dotnet xml:

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

Re: typed datasets and duplicated relations

Iain
12/29/2003 9:37:19 PM

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
[quoted text, click to view]