managing transaction to avoid deadlock

Question

mehmood tekfirst 771

Hi,

I want to perform a quick transaction using ef core 6.

This mechanism should be defined in such a way that a deadlock 'll never be happened/occured.

In my code logic, I am sometimes inserting in database entities through

_dbcontext.payments.add( new payment(){amount=20});

and there are some updates and the remaining ones are related to stored procedures call.

inserts and updates in it.

Can anyone suggest me some excellent way to implement a transaction or a best way to avoid deadlocks/blocking here.

I want to complete the commit to either complete or revert/abort the work.

Thank you so much

Jack J Jun 25,306 Reputation points

2022-07-05T07:06:28.887+00:00

@mehmood tekfirst ，Welcome to Microsoft Q&A, Did you meet some errors when you use the above code? If so, Please tell me about it. Or did you just worry about avoiding deadlock?
mehmood tekfirst 771 Reputation points

2022-07-05T07:22:20.773+00:00

I am just worrying about deadlock when I 'll use transaction.

Thats' why I am asking here is there any recommended approach to use a transaction which can avoid deadlocks ?

I was working in Asp.Net MVC 5 before using Asp.Net MVC CORE 6 (with EF Core 6).

So It must be some new ways to implement a transaction in a better way.

In past , we had some experiences of deadlocks

2 answers

Jack J Jun 25,306 Reputation points

2022-07-05T07:06:28.887+00:00

@mehmood tekfirst ，Welcome to Microsoft Q&A, Did you meet some errors when you use the above code? If so, Please tell me about it. Or did you just worry about avoiding deadlock?
mehmood tekfirst 771 Reputation points

2022-07-05T07:22:20.773+00:00

I am just worrying about deadlock when I 'll use transaction.

Thats' why I am asking here is there any recommended approach to use a transaction which can avoid deadlocks ?

I was working in Asp.Net MVC 5 before using Asp.Net MVC CORE 6 (with EF Core 6).

So It must be some new ways to implement a transaction in a better way.

In past , we had some experiences of deadlocks

Answer 1

Olaf Helper 47,621

I am just worrying about deadlock when I 'll use transaction.

What's the data destination, a MS SQL Server or ...?
You can not completly avoid deadlocks, they happens in real world.

0 comments

Answer 2

mehmood tekfirst 771

Sql server

0 comments