Мобильная версияI'm developing an ASP.NET Core 8 API with Angular frontend (both hosted in Azure App Service). In the frontend application, I have a dashboard page that needs to display data pulled from multiple databases hosted in Azure SQL. The challenge is that the data displayed on the dashboard might be getting updated at the individual database level concurrently.
I'm seeking advice on the best-performing approach to implement this scenario. Specifically, I'm looking for guidance on:
What is the best practice for efficiently pulling data from multiple Azure SQL databases in an ASP.NET Core API? How can I ensure the data displayed on the dashboard is real-time or near real-time, considering potential updates happening at the database level? Are there any recommended architectural patterns or technologies to handle this scenario effectively? If possible, could you provide code references or examples demonstrating the implementation of the suggested approach?
Can anyone please help me here by providing their guidance
Источник: https://stackoverflow.com/questions/780 ... r-frontend
