blocks|key|4004819|text|可以将存储过程映射到DataContext上的方法，该方法删除主键具有给定值的记录。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4004820|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can map a stored procedure to a method on the DataContext that deletes a record with a given value for the primary key.

blocks|key|4004880|text|我一直使用select-delete方法，因为它非常简单。正如marxidad所说，如果您真的想映射一个存储的proc，您可以这样做。我相信将来有计划让ESQL支持插入、更新和删除操作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4004881|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I've always used the select-delete approach as it's very straight-forward. As marxidad said, you can map a stored proc if you really want to. I believe there are plans for ESQL to support insert, update and delete operations in the future.

blocks|key|5416487|text|这种方法是可以接受的，也是典型的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5416488|这有点浪费，因为您请求的是整个记录。考虑到DeleteOnSubmit方法签名，这是无法避免的。|5416489|为什么LINQ+to+SQL是这样工作的？如果您考虑没有主键或使用组合键的表，答案是显而易见的。LINQ+to+SQL需要完整的记录，以防万一，它需要将每个对象属性与表字段进行匹配。|5416490|但是，对于性能方面的所有问题，您是否完全确定这是一个性能问题？你的分析证据在哪里？|5416491|我还没有尝试过这一点，但也许有一种方法可以用DataContext.ExecuteCommand实现相同的功能。|offset|length|5416492|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.executecommand.aspx^0|0|0|0|0|M|Q|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@$J|Y|K|Z|1|10]]|A|$]]|$1|L|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

That approach is acceptable and typical. 

It is a little wasteful because you're requesting the whole record. This cannot be avoided given the DeleteOnSubmit method signature. 

Why does LINQ to SQL work this way? The answers obvious if you think about tables that do not have primary keys, or use composite keys. LINQ to SQL needs the whole record for the worst case where it needs to match every object property against the table fields. 

But as should be asked for all concerns of performance - are you absolutely sure this is a performance issue for you?? Where's your profiling proof?

I haven't tried this yet but there might be a way to achieve the same thing with <a href="http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.executecommand.aspx" rel="nofollow noreferrer">DataContext.ExecuteCommand</a>.

blocks|key|5416551|text|我最终做了一个select，但改进了我的语法，我认为这是我真正关心的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5416552|旧的：|5416553|var+products+=+from+p+in+db.Products+select+p;
db.Products.DeleteOnSubmit(products.Take(1).Single());+<--seemed+nasty
db.SubmitChanges();|code-block|syntax|javascript|5416554|新的：|5416555|Service+service+=+db.Services.Where(s+=>+s.id+==+serviceID).FirstOrDefault();+<--nicer
db.Services.DeleteOnSubmit(service);
db.SubmitChanges();|5416556|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I ended up doing a select, but improved my syntax which I think was really my concern:

Old:

<pre><code>var products = from p in db.Products select p;
db.Products.DeleteOnSubmit(products.Take(1).Single()); &lt;--seemed nasty
db.SubmitChanges();
</code></pre>

New:

<pre><code>Service service = db.Services.Where(s =&gt; s.id == serviceID).FirstOrDefault(); &lt;--nicer
db.Services.DeleteOnSubmit(service);
db.SubmitChanges();
</code></pre>

blocks|key|836936|text|++public+static+Delete(this+ITable+table,+object+key)
+++{+var+t+=+table.GetType();
+++++var+tableName++=+t.GetCustomAttributes
++++++++++++++++++++++++++++++++++++(typeof(TableAttribute),false)[0].Name;
+++++var+primaryKey+=+(from+p+in+t.GetProperties()
+++++++++++++++++++++++from+c+in+p.GetCustomAttributes
++++++++++++++++++++++++++++++++++++++++++++(typeof(ColumnAttribute),false)
+++++++++++++++++++++++where+c.IsPrimaryKey
+++++++++++++++++++++++select+c.Name).Single();
+++++using+(var+cmd+=+table.Context.Connection.CreateCommand())
++++++{+cmd.CommandText+=+string.Format(+"DELETE+FROM+{0}+WHERE+{1}+=+@key"
++++++++++++++++++++++++++++++++++++++++,tableName,+primaryKey);
++++++++cmd.Parameters.Add(new+SqlParameter("@key",+key));
++++++++cmd.ExecuteNonQuery();++++++++
++++++}++++++++++++
+++}

/*+...+*/
dataContext.Table1.Delete(id);|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|836937|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> public static Delete(this ITable table, object key)
 { var t = table.GetType();
 var tableName = t.GetCustomAttributes
 (typeof(TableAttribute),false)[0].Name;
 var primaryKey = (from p in t.GetProperties()
 from c in p.GetCustomAttributes
 (typeof(ColumnAttribute),false)
 where c.IsPrimaryKey
 select c.Name).Single();
 using (var cmd = table.Context.Connection.CreateCommand())
 { cmd.CommandText = string.Format( "DELETE FROM {0} WHERE {1} = @key"
 ,tableName, primaryKey);
 cmd.Parameters.Add(new SqlParameter("@key", key));
 cmd.ExecuteNonQuery(); 
 } 
 }

/* ... */
dataContext.Table1.Delete(id);
</code></pre>

blocks|key|3159345|text|如果将所有列上的update+checks设置为never或when+changed，则可以简单地附加一个具有主键的实例，并在不加载的情况下删除行。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3159346|public+void+DeleteCustomer(int+CustomerID)
{
++++NorthwindContext+c+=+new+NorthwindContext+c;
++++Customer+target+=+new+Customer(){CustomerID+=+CustomerID};
++++c.Customers.Attach(target);
++++c.Customers.DeleteOnSubmit(target);
++++c.SubmitChanges();+++++++++++++++++++++++
}|code-block|syntax|javascript|3159347|entityMap^0|8|D|O|5|U|C|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|L|$]]

If you set update checks on all your columns to never or when changed, you can simply attach an instance with the primary key and delete the row without a load.

<pre><code>public void DeleteCustomer(int CustomerID)
{
 NorthwindContext c = new NorthwindContext c;
 Customer target = new Customer(){CustomerID = CustomerID};
 c.Customers.Attach(target);
 c.Customers.DeleteOnSubmit(target);
 c.SubmitChanges(); 
}
</code></pre>

What is the best way to delete a database record using LINQ when I have the primary key?

Cleanest syntax to delete a record in linqtosql

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

当我有主键时，使用LINQ删除数据库记录的最佳方法是什么？

问在linqtosql中删除记录的最干净的语法
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在linqtosql中删除记录的最干净的语法EN