CODEWITHSUNDEEP
linq-to-sqlprimary-keydelete-rowdelete-record
Jeremy
Jeremy

Reputation: 46380

How to delete using only the primary key?

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?

Upvotes: 9

Views: 3519

Answers (2)

ratty
ratty

Reputation: 13444

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

Upvotes: 4

bkaid
bkaid

Reputation: 52073

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

Upvotes: 4

Related Questions