title: How to update Dataset Parent & Child tables with Autogenerated Identity Key?
body: <p>I am using ADO.NET Datasets in my VB Applications. I have a typed dataset with one Parent table and many child tables. I want to generate Identity Key when I insert data into Parent Table and then update the data in all child tables with the Same key (As Foregin key).</p>
  
  <p>At last, I want to update the dataset in Database(SQL Server08).</p>
  
  <p>Well, the above thing can be possible by first inserting Parent Table in Database directly, get the Identity column and than use to for Child tables.</p>
  
  <p>But I want to this as an automatic operation (Like LINQ to SQL which takes care of Primary &amp; Foreign key in datacontext.)</p>
  
  <p>I such thing possible in Dataset which takes care of Autogenerated column for Parent and child tables?</p>
  
  <p>Thanks,</p>
  
  <p>ABB</p>