I get sql deadlock error came using webapi post method. how to handle multiple request at a time .

Question

User-2025101118 posted

 'public void mypostfunction()
      {
        //call Webapi post method here
        }'

      --using this code to sent multiple request a time. 
   'for (int i=0; i< count; i++)
        {
            new Thread(() =>
            {
                Thread.CurrentThread.IsBackground = true;
                mypostfunction();
            }).Start();
       }'

  --Webapi Route Method
    '[Route("example/mypostfunction/")]
    [System.Web.Http.HttpPost]
    public async Task<HttpResponseMessage> Examplepost(Getvaues value)
    {

      }'

Answer 1

User475983607 posted

What is the actual error?  Can you post the SQL code that causes the error?  

This code pattern is a problem.   mypostfunction() should be async. 

for (int i=0; i< count; i++)
{
	new Thread(() =>
	{
		Thread.CurrentThread.IsBackground = true;
		mypostfunction();
	}).Start();
}

Answer 2

User1120430333 posted

How do you know that you are getting a SQL Deadlock on a table?

Answer 3

User-1408112258 posted

I have no idea, really, but if anyone knows how to solve this, let them comment, it is in the interest of many of us.
big thanks 

Answer 4

User1120430333 posted

I have no idea, really, but if anyone knows how to solve this, let them comment, it is in the interest of many of us.
big thanks 

https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-isolation-levels

https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table