Linq to SQL: How to delete using only the primary key?

Question

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

Answer 1

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();

Answer 2

Linq to SQL: Delete an entity using Primary Key only - Omar AL ...

http://msmvps.com/blogs/omar/archive/2008/10/30/linq-to-sql-delete-an-entity-using-primary-key-only.aspx