title: Implementing a parent children object in .Net, SQL server
body: <p>I have developed a web application with a timesheet object. The object has as property a List. In SQL Server this is reflected in 2 tables, Timesheets and TimesheetEntries, with TimesheetEntries having a foreign key pointing to the PK (Id autonumber) of the Timesheets table.
  Currently the timesheet object is displayed on a grid where the user makes inserts and amendments to the entries and finally saves it. </p>
  
  <p>In saving the timesheet, I delete all timesheet entries and then re-create them. Of course this pushes the autonumber field of the TimesheetEntries up every time the user saves the timesheet.</p>
  
  <p>Is this the best way to achieve this? Is there a better way to do this?</p>