checking, operation successful after any LinqToSql operation

Question

We normally use these statements to add anew record to database.

MyDataContext.InsertOnSubmit(AnObject);
MyDataContext.SubmitChanges();

Other than using stored procedure(can return a value by "Return / Output"), is there a way to return a value indicating, operation was successful ? probably, Linq own methods / functions

Any idea, Thanks

Answer 1

Couldn't use a try and catch block and trap the appropriate errors?

Answer 2

If the operation is not successful, then it will throw an exception. If it doesn't throw an exception, then it was successful.