Deadlock detection

Hi,

I am a novice DevForce developer, so my question is probably very trivial.

Is there a way to detect deadlock errors (or to distinguish any other data provider errors) when EntityManager.SaveChanges/SaveChangesAsync fails? I want to retry saving changes if they fail due to the database deadlock.  When deadlock occurs I can see a particular type of exception on a server side in EntityServerSaveInspector.OnError as an InnerException but I am not sure if I can retry at this point.  On a client side, error is returned as a generic EntityManagerServerException and InnerException is not set.  I can see RemoteExceptionDetails but I cannot see the original error number, so I cannot make a determination that it’s a deadlock error.

Thank you,

Rita

Hi Silvio,

We have done some optimization to prevent deadlocks.  But in case they still occur I want to add an ability for the application to retry the save.  I can retry calling SaveChangesAsync from the client but I need to have a way to determine that the error was in fact a deadlock error.  Currently, on a client I can only get exception message, stack and etc. (RemoteException properties of EntityManagerException) and generic FailureType.  I need to find something in the EntityManagerSaveException that will tell me the error number.

In case of a deadlock, EntityServerSaveInterceptor.OnError inner exception is System.Data.SqlClient.SqlException, error number 1205.

Thank you,

Rita