How to delete using only the primary key?

delete-record, delete-row, linq-to-sql, primary-key

Solution

You should be able to create an instance of the object with the appropriate FK and then Attach() it to the context, Delete() it and then SubmitChanges() which will perform a delete without performing a sql select.

var foo1 = new Foo {Id = 1};
db.Foos.Attach(foo1);
db.Foos.Remove(foo1);
db.SubmitChanges();

Problem

How do I delete a record using Linq to SQL using only the primary key, without having to retrieve the existing record from the database?

Original source