Duplicate a database record with linq

Question

Is there a way to duplicate a db record with linq to sql in c#?

Id [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[Foo] [nvarchar](255) NOT NULL,
[Bar] [numeric](28,12) NOT NULL,
...

Given the table above, I would like to duplicate a record (but give it a different id), in a way that new fields added to the DB and the Linq dbml file at a later date will still get duplicated with out having to change that code that duplicates the record.

ie I don't want to write newRecord.Foo = currentRecord.Foo; for all of the fields on the table.

Answer 1

I am not sure if this is what you want, but the following thread includes code using reflection and an extension method on DataContext to allow you to easily copy the members of one entity into another.

http://stackoverflow.com/questions/637535/duplicate-linq-to-sql-entity-record