title: Bulk Insert in multiple relational tables using Dapper .Net-using scope identity
body: <p>I need to import millions of records in multiple sql server relational tables.</p>
  
  <pre><code>TableA(Aid(pk),Name,Color)----return id using scope identity 
  TableB(Bid,Aid(fk),Name)---Here we need to insert Aid(pk) which we got using scocpe Identity
  </code></pre>
  
  <p>How I can do bulk insert of collection of millions of records using dapper in one single Insert statement</p>