如何通过lInq到sql delete查询从具有外键关系的表中删除数据 [英] How to delete datas form a table with foreign key relation via lInq to sql delete query

问题描述

如何通过lInq到sql delete查询从具有外键关系的表中删除数据。

How to delete datas form a table with foreign key relation via lInq to sql delete query.

推荐答案

最简单的方法是不要通过Linq to SQL来实现。为什么不设置你的关系使用级联删除自动删除？



http://msdn.microsoft.com/en-us/library/ms186973（SQL.90）.aspx [ ^ ]



http://www.mssqltips.com/sqlservertip/2743 / using-delete-cascade-option-for-foreign-keys / [ ^ ]



但如果是linq你就是希望这有助于



级联删除在LINQ to SQL中 [ ^ ]

The easiest way is not to do it through Linq to SQL. Why not set your relation to automatically delete using cascading deletes?

http://msdn.microsoft.com/en-us/library/ms186973(SQL.90).aspx[^]

http://www.mssqltips.com/sqlservertip/2743/using-delete-cascade-option-for-foreign-keys/[^]

But if it is linq you were after then hope this helps

Cascading Deletes in LINQ to SQL[^]

这篇关于如何通过lInq到sql delete查询从具有外键关系的表中删除数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！