Search code examples
c#linq-to-sqlexceptiondatacontextsubmitchanges

Exceptions by DataContext


I've been doing some searching on the internet, but I can't seem to find the awnser. What exceptions can a DataContext throw? Or to be more specific, what exceptions does the DataContext.SubmitChanges() method throw?

EDIT
For reference, here a List of possible known exceptions that could be thrown by the L2S DataContext:

  • SqlException
  • ChangeConflictException
  • DuplicateKeyException
  • ForeignKeyReferenceAlreadyHasValueException
  • OutOfMemoryException (when not correctly disposing the DataContext)

Solution

  • You're right, MSDN is not a great help here. This is what I can remember from the top of my head:

    • SqlException (from the ADO.NET layer)
    • ChangeConflictException (L2S)
    • DuplicateKeyException (L2S)
    • Anything that cusomized overrides (partial void OnXXXEntity) may raise