Apologies for the vague question. Here it is: I have a table object created by LINQ to SQL. I am copying entries from one table to an "archive" table that has all the columns of the original, plus a couple extra ones.

It feels sloppy to iterate through every object and manually define the mapping like:

foreach (oldTable in dbContextOldTables)
{
   var newTable = new NewTable();
   newTable.TableID = oldTable.ID;
   newTable.Title = oldTable.Title;
   ... (repeat for twenty columns)
   newTable.ColumnThatIsntInOldTable = "Data that will be the same for every row";
   dbContext.NewTables.InsertOnSubmit(newTable);
} 
dbContext.SubmitChanges();

Is there a clever way to do this?