.net - 删除LINQ to SQL记录而不先加载它

Question

是否可以使LINQ to SQL使用PK删除记录，而无需先加载记录？与NHibernate的代理对象功能类似吗？

Answer 1

您应该可以这样做:

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
}