Converting Dataset to Xml file
<p>I have added DataSet at design time by 'Add -> New Item -> DataSet -> DataSet1.xsd'<br>
So, I have added all the required tables along with setting their 1:1 or 1:M relations.</p>

<p>When I write this DataSet to XML file using WriteXml(), I get something like -</p>

<pre><code>&lt;Term&gt;
  &lt;TermId&gt;1&lt;/TermId&gt;
  &lt;Title&gt;Term1&lt;/Title&gt; 
  &lt;ContactTeacher&gt;
    &lt;TermId&gt;1&lt;/TermId&gt;
    &lt;FirstName&gt;A1&lt;/FirstName&gt;
    &lt;LastName&gt;A1L&lt;/LastName&gt;
  &lt;/ContactTeacher&gt;
  &lt;ContactTeacher&gt;
      &lt;TermId&gt;1&lt;/TermId&gt;
      &lt;FirstName&gt;B1&lt;/FirstName&gt;
      &lt;LastName&gt;B1L&lt;/LastName&gt;
  &lt;/ContactTeacher&gt;
&lt;/Term&gt;
</code></pre>

<p>So, as you see in above Xml, child table 'ContactTeacher' is having its FK column TermId appearing in the output.<br>
I am having this TermId column in child table to set relation between the tables.</p>

<p>Is there anyway I can avoid FK columns from Child tables to result in output XML?<br>
Or should I go for generating customized Xml output from Dataset tables - Is Linq to XML is a good choice to handle this?</p>
