Delete a LINQ to SQL record without loading it first

Question

Is it possible to get LINQ to SQL to delete a record using the PK, without loading the record first? Similar to NHibernate's proxy object functionality?

Joseph · Accepted Answer · 2009-08-21 14:43:17Z

16

You should be able to do it this way:

var person = new Person();
person.ID = someID;

using (var context = new DataContext(connString))
{
    context.Persons.Attach(person, false); //attach is as unmodified
    context.Persons.DeleteOnSubmit(person); //remove it
    context.SubmitChanges(); //submit changes to db
}

edited Aug 21, 2009 at 14:43

answered Aug 21, 2009 at 14:17

Joseph

25.6k8 gold badges83 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pennidren · Accepted Answer · 2012-08-22 01:57:26Z

3

Adding to Joseph's answer:

You may have trouble deleting in this manner if your entity has any fields for which UpdateCheck is set to Always, unless you set such fields as appropriate.

Also, if you are deleting multiple related entities where FK constraints are involved, you may have trouble if the entities are not deleted in the proper sequence (resulting in a constraint violation). To avoid this, set all fields involved in such FKs as appropriate.

answered Aug 22, 2012 at 1:57

Pennidren

1111 silver badge5 bronze badges

Collectives™ on Stack Overflow

Delete a LINQ to SQL record without loading it first

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related