Generalizing Order Processing for Multiple ASP.NET Sites

Frontend and Backend Development
1

I’m working with a client for whom we’ve built about 10 ASP.NET web applications, each handling order creation differently. I’m seeking a more unified method to process orders from all sites. Right now, I loop through each site to check for pending orders in a console app, which doesn’t seem efficient. For instance, if one site has 1000 pending orders, processing those will halt the others. Here are some ideas I’ve considered:

  1. Manage each order processing request with separate threads, imposing a limit.
  2. Utilize SQL Server Agent for triggering web service calls.

What would be a more effective way to implement this?

The sites are built with ASP.NET Web Forms, C#, and SQL Server 2008.

2

Have you considered event-driven architecture with message queues? It can decoupl your systems and balance load dynamically. I’m curious if wrapping your logic around some cloud functionalities like Azure Functions might help? They can scale based on demand, so evry order gets processed as it comes.