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 existing record from the database?

Don't have VS to test this at the moment but wouldn't it be something like this: DataContext.Widgets.Delete(new {id = 123}) — nathanchere, Mar 08 '10 at 05:37
FerretallicA - Nope, I would have figured that out if it was the case. :) — Jeremy, Mar 16 '10 at 15:08

score 4 · Answer 1 · answered Mar 08 '10 at 05:18

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

score 4 · Answer 2 · answered Mar 08 '10 at 05:21

4

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

answered Mar 08 '10 at 05:21

ratty

13,216
29
75
108

+1 yup basically you need straight SQL for this, Linq-to-SQL doesn't support it natively.... – marc_s Mar 08 '10 at 05:53

How to delete using only the primary key?

2 Answers2