Hi all,

I'm having some trouble on generating strongly typed datasaets based on my 
xml schema. 
The schema is something like this(very simplified):
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Books" targetNamespace="http://tempuri.org/Books.xsd" 
elementFormDefault="qualified" xmlns="http://tempuri.org/Books.xsd" 
xmlns:mstns="http://tempuri.org/Books.xsd" 
xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="Author">
    <xs:complexType>
      <xs:sequence>
        <xs:element name="ID" type="xs:int" />
        <xs:element name="Name" type="xs:string" />
        <xs:element name="Book">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ISBN" type="xs:int" />
              <xs:element name="Title" type="xs:string" />
              <xs:element name="AuthorID" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
    <xs:key name="AuthorKey1">
      <xs:selector xpath="." />
      <xs:field xpath="mstns:ID" />
    </xs:key>
    <xs:keyref name="AuthorBooks" refer="AuthorKey1">
      <xs:selector xpath=".//mstns:Book" />
      <xs:field xpath="mstns:AuthorID" />
    </xs:keyref>
  </xs:element>
</xs:schema>

Quickly explained, this is a table of authors and a childtable containing 
the books of each author. I have used an unique ID to identify authors, which 
is planned to act as a foreign key in the book table. 
However, when I generate datasets using MSDataSetGenerator, an additional id 
called Author_ID is added to the author table and used as a foreign key in 
books. This way I lose a lot of control, as my relation(primary/foreign key) 
is discarded. 

Can anyone help me with this issue? I'll be glad to elaborate more if needed.


Regards,
Sven-Erik Nilsen