title: Retrieve auto increment id of last inserted record in MVC 4
body: <p>MVC 4 has been a very tough nut to crack for me. I am using three tables in a SQL Compact database. </p>
  
  <p><code>Accounts</code> Table is saved first (which I have done) but the <code>Phones</code> and <code>Data</code> table use <code>AccountsID</code> as a foreign key. MVC 4 does all the database work through the <code>Model</code> and the <code>View</code> so how can I get <code>AccountsID</code> from the newly added row in the Database through MVC 4 and  provided it to the Phones and Data Models so everything saves correctly?  </p>