title: ASP.Net web service synchronize call to process database queue
body: <p>I have an asp.net web service which is like a reservation system and cannot reserve the same seat by multiple persons and the eligibility for the reservation is based on some other table values in SQL server. I plan to use SQL server queue processing as mentioned <a href="http://www.adathedev.co.uk/2010/03/queue-table-processing-in-sql-server.html" rel="nofollow noreferrer">here</a>. My customer wants to do this in a synchronized call, means we want the result in the same web service method call. My question is how efficient it to allow a synchronized method call to process a queue and wait until the queue return values (by means of a loop within a time span or so). Please advise the best possible approaches to achieve this. </p>