C Web API多个方法调用方写入数据库

我希望有人能帮我把这个方法写得更好。这个方法一直工作,直到我有多个用户同时点击这个方法。我开始使用Async/Wait,但我不知道它是否适合我。最大的问题是我们有一个保存到的临时/工作表,然后对该表执行一个存储过程,该存储过程执行一些操作,并在完成后清除该表。表中的数据是特定于用户的,因此我们只需要其中的数据就可以让用户执行存储过程。如果有其他数据进入,就会把事情搞砸。这就是为什么在我们继续之前,我要检查确保桌子是空的。

简言之,我如何才能使这个方法以真正的RESTful方式工作,并为许多用户提供可伸缩性?

[HttpPost, Route("api/SubmitOrder")]
public IHttpActionResult SubmitOrderEntry([FromBody] OrderRequest request)
{
    var profileObjs = OrderEntities.Set<OrderStaging>();
    foreach (var s in request.Items)
    {
        OrderStaging orderObj = new OrderStaging();

        orderObj.OrderName = request.OrderName;
        orderObj.OrderDescription = request.OrderDescription;
        orderObj.OrderComments = request.Comments;
        orderObj.EnteredBy = request.EnteredBy;
        //and many more

        profileObjs.Add(orderObj);
    }

    try
    {
        bool tableEmpty = false;
        int count = 0;
        int countMax = 180;

        while (!tableEmpty && count < countMax)
        {
            count++;
            if (!OrderEntities.OrderStagings.Any())
            {
                tableEmpty = true;
            }
            else
            {
                System.Threading.Thread.Sleep(5000);
            }
        }

        if (tableEmpty)
        {
            OrderEntities.Configuration.EnsureTransactionsForFunctionsAndCommands = false;
            OrderEntities.Database.CommandTimeout = 180;
            OrderEntities.SaveChanges();

            if (request.Pending)
            {
                var result = OrderEntities.SPPENDING();
                var firstRow = result.FirstOrDefault();
                String[] returnValue = new String[] { firstRow.TransactionID, firstRow.ExternalOrderID };
                return Ok(returnValue);
            }
            else
            {
                var result = OrderEntities.SPORDER();
                var firstRow = result.FirstOrDefault();
                String[] returnValue = new String[] { firstRow.TransactionID, firstRow.ExternalOrderID };
                return Ok(returnValue);
            }
        }

        return Content(HttpStatusCode.BadRequest, "SQL Server Exception");
    }
    catch (Exception e)
    {
        Console.WriteLine(e.ToString());
        return Content(HttpStatusCode.BadRequest, "SQL Server Exception");
    }
}