fantamen
asked on
Parallel transactions and entity framework
I've a web service used to append data from source A (company ERP) to source B (sql production database). Web Service can be invoked n times.
Sometimes an exception occured: System.InvalidOperationExc eption: SqlConnection not support parallel transaction and the specific code area where I suppose is located the problem is this sub:
Friend Sub Aggiungi_AnaCarichi()
Dim NuovoPianoCarico As New AnaCarichi
With NuovoPianoCarico
.NumPianoCarico = _NumPianoCarico
.DataCarico = _DataCarico
.DataElaborazione = Date.Now
.Descrizione = _Descrizione
.IDStato_PCarico = "0"
End With
dbLineProdContext.AddToAna Carichi(Nu ovoPianoCa rico)
Try
dbLineProdContext.SaveChan ges()
' Salvo il valore della colonna identity IDPianoCarico, mi servirà quando dovrò salvare
' i dati in Carichi_Padri, Carichi_PadriVarianti e Carichi_Figli.
_IDPianoCarico = NuovoPianoCarico.IDPianoCa rico
Catch ex2 As OptimisticConcurrencyExcep tion
dbLineProdContext.Refresh( Objects.Re freshMode. ClientWins , dbLineProdContext.AnaCaric hi)
dbLineProdContext.SaveChan ges()
_IDPianoCarico = NuovoPianoCarico.IDPianoCa rico
Catch ex3 As UpdateException
pvclErrori.Codice = 1
pvclErrori.Descrizione &= "Salvataggio nuovo p.d.c. in AnaCarichi: " & ex3.Message & vbCrLf
End Try
End Sub
I use entity framework. AnaCarichi is an entity of the entity model dbLineProdContext.
What can I do to solve the problem?
Sometimes an exception occured: System.InvalidOperationExc
Friend Sub Aggiungi_AnaCarichi()
Dim NuovoPianoCarico As New AnaCarichi
With NuovoPianoCarico
.NumPianoCarico = _NumPianoCarico
.DataCarico = _DataCarico
.DataElaborazione = Date.Now
.Descrizione = _Descrizione
.IDStato_PCarico = "0"
End With
dbLineProdContext.AddToAna
Try
dbLineProdContext.SaveChan
' Salvo il valore della colonna identity IDPianoCarico, mi servirà quando dovrò salvare
' i dati in Carichi_Padri, Carichi_PadriVarianti e Carichi_Figli.
_IDPianoCarico = NuovoPianoCarico.IDPianoCa
Catch ex2 As OptimisticConcurrencyExcep
dbLineProdContext.Refresh(
dbLineProdContext.SaveChan
_IDPianoCarico = NuovoPianoCarico.IDPianoCa
Catch ex3 As UpdateException
pvclErrori.Codice = 1
pvclErrori.Descrizione &= "Salvataggio nuovo p.d.c. in AnaCarichi: " & ex3.Message & vbCrLf
End Try
End Sub
I use entity framework. AnaCarichi is an entity of the entity model dbLineProdContext.
What can I do to solve the problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER