Downloads: 0 | Views: 0
Research Paper | Information Technology | United States of America | Volume 10 Issue 6, June 2021 | Popularity: 3.2 / 10
Performance - Driven Design of Scalable Web APIs Using .Net Core 3.1, Entity Framework Core, and SQL Server on Azure App Services
Dheerendra Yaganti
Abstract: This paper presents a robust methodology for designing scalable, high - performance Web APIs utilizing. NET Core, Entity Framework Core, and SQL Server deployed on Azure App Services. The focus is on enhancing throughput and responsiveness in cloud - hosted environments by strategically optimizing database queries, leveraging connection pooling, and offloading long - running operations through background processing. The proposed architecture embraces asynchronous programming patterns and leverages dependency injection to build modular, testable components. To improve data access efficiency, the study explores LINQ query optimizations, tracked versus untracked contexts, and stored procedure integration via EF Core. Connection resiliency and pooling mechanisms are configured to ensure stable performance under fluctuating loads, while background task handling is implemented using hosted services to separate resource - intensive operations from the request pipeline. The system is evaluated through controlled load testing on Azure App Services, with metrics collected for request latency, CPU usage, and throughput. Results demonstrate significant gains in scalability and reliability, validating the proposed framework?s suitability for enterprise - grade applications. This work provides practical insights for developers and architects seeking to deploy performant APIs in managed cloud environments using modern, production - ready Microsoft technologies.
Keywords: .NET Core, Entity Framework Core, Web API, SQL Server, Azure App Services, Query Optimization, Connection Pooling, Background Processing, Asynchronous Programming, Cloud Deployment, Dependency Injection, Hosted Services, Performance Engineering
Edition: Volume 10 Issue 6, June 2021
Pages: 1883 - 1887
DOI: https://www.doi.org/10.21275/SR210611095250
Please Disable the Pop-Up Blocker of Web Browser
Verification Code will appear in 2 Seconds ... Wait