title: Insert into parent-child tables in SQL Server
body: <p>I have multiple level parent-child tables(GrandParent, Parent and Child, all many to one relation, one parent has multiple children, all children have one parent). Each has auto identity keys. Using C# and stored procedure, how to insert to them with foreign key constrains?
  For example, the data to be inserted include multiple grand parents, each grad parent has multiple parents and each parent multiple children. </p>
  
  <p>Sample data: </p>
  
  <pre><code>campus &lt;- building &lt;- office
  </code></pre>
  
  <p>Adding a few campuses and associated buildings/offices.</p>