Is Linq to Sql DeleteOnSubmit threadsafe?

Question

Assuming the decision to delete is independent and threadsafe, is it threadsafe to call DeleteOnSubmit in parallel?

All entities will be added to the delete in parallel, then the change will be submitted afterwards.

My testing hasn't shown a problem, but that doesn't inherently mean it's safe....

SLaks · Accepted Answer · 2013-06-06 21:56:56Z

1

No.

LINQ to SQL itself is not thread-safe; nor are any of its methods.

answered Jun 6, 2013 at 21:56

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Do you have a link describing this?
– Matthew
Commented Jun 6, 2013 at 21:57
social.msdn.microsoft.com/forums/en-US/linqprojectgeneral/… blog.stevensanderson.com/2007/11/29/…
– SLaks
Commented Jun 6, 2013 at 21:59
I see that the datacontext is not threadsafe as a whole, because many things can be called from it. That doesn't mean that adding to the deletion list isn't threadsafe... does it?
– Matthew
Commented Jun 6, 2013 at 22:02
I highly doubt that it's thread-safe. Thread safe code does not happen by accident; it requires careful design and compromises. For example, what if the list resizes?
– SLaks
Commented Jun 6, 2013 at 22:08

1 Answer 1