select Count(Productid) as PrCount from products
group by ProducId
Having(PrCount)> 10
OpenID
1. Throttling in web API
Throttling in a Web API means controlling the number of requests a client/user can make within a specific time window. It’s mainly used to protect the API from abuse, ensure fair usage among clients, and maintain performance under heavy load.
Why Throttling is Needed
-
Prevent abuse / DoS attacks – stops a single client from overwhelming the server.
-
Fair usage – ensures all clients get equal access.
-
Performance stability – prevents spikes from crashing the API.
-
Cost control – especially for cloud-hosted APIs (Azure, AWS) where usage costs matter.
2.What is Versioning in web API?
Versioning in Web API is the practice of managing changes to your API without breaking existing clients. Since APIs evolve over time (new features, deprecations, contract changes), versioning ensures backward compatibility while still allowing improvements.
Why API Versioning?
-
Clients using old versions don’t break when API changes.
-
Supports gradual migration to newer versions.
-
Allows experimentation and safe deprecation of old endpoints.
load balaning in web api traffic
private constructor
ModelBinder
Agile Methodoligies
Dockers
MessageBrokers
oops
ioc
DI
olap and Dynamics
versions
Functions and Methods in C#
Micro services
Design Patterns
Azure Interview Questions And Answers
What are the differences between Saas, PaaS, and IaaS Cloud Services?
SaaS: Software as a Service
Using their Software Application and orgnization paying for that.
PaaS : Platform a
AZure APPS
Azure Pass
Azure Cloud
Azure Bus
Azure Key Vault
JWT Tokens
javascript vs Jquery
improving message bus queue
Referral Questions:
Topic
Question
.NET Core
What is the difference between .NET Core and .NET Framework?
.NET Core
Explain the purpose of the IServiceProvider interface in .NET Core Dependency Injection.
.NET Core
How does middleware work in .NET Core, and how can you create custom middleware?
.NET Core
What is the use of IHostedService in .NET Core applications?
.NET Core
How do you implement configuration management in a .NET Core application?
.NET Core
What are the differences between IApplicationBuilder and IWebHostBuilder?
.NET Core
Explain the difference between a self-contained deployment and a framework-dependent deployment in .NET Core.
.NET Core
How can you handle logging in .NET Core using the built-in logging framework?
.NET Core
What are the benefits of using the Kestrel web server in .NET Core?
.NET Core
How do you implement Health Checks in a .NET Core application?
C#
What are the main differences between abstract classes and interfaces in C#?
C#
What is the purpose of the using statement, and how does it work with the IDisposable interface?
C#
Explain the difference between value types and reference types in C#.
C#
What is the difference between Task and Thread in C#?
C#
How do you implement exception handling using try-catch-finally in C#?
C#
Explain the concept of async and await in C#.
C#
What are the differences between readonly, const, and static keywords in C#?
C#
How does yield work in C#? Provide an example.
C#
What is the difference between String and StringBuilder in C#?
C#
How do extension methods work in C#, and how are they implemented?
OOPS
What are the four principles of Object-Oriented Programming (OOP)? Explain each.
OOPS
How does polymorphism work in C#, and what are its types?
OOPS
What is encapsulation, and how is it implemented in C#?
OOPS
Explain the concept of inheritance and its types with examples.
OOPS
What is the difference between method overloading and method overriding?
OOPS
How do constructors and destructors work in C#?
OOPS
What is the difference between an abstract class and a concrete class?
OOPS
Explain the concept of interfaces in OOP. How are they different from abstract classes?
OOPS
What is the purpose of design patterns in OOP, and can you give an example of one?
OOPS
What is the concept of dependency inversion in OOP?
ASP.NET Core API
How do you create a RESTful API in ASP.NET Core?
ASP.NET Core API
What is the purpose of the Startup class in an ASP.NET Core application?
ASP.NET Core API
How do you handle authentication and authorization in ASP.NET Core API?
ASP.NET Core API
Explain the difference between AddControllers and AddControllersWithViews.
ASP.NET Core API
How do you version APIs in ASP.NET Core?
ASP.NET Core API
What are the benefits of using attribute routing in ASP.NET Core?
ASP.NET Core API
How do you handle model validation in ASP.NET Core Web APIs?
ASP.NET Core API
What is the purpose of the ActionResult<T> return type in ASP.NET Core?
ASP.NET Core API
How can you implement Swagger for API documentation in ASP.NET Core?
ASP.NET Core API
How do you enable and use CORS in an ASP.NET Core API?
Angular
What are the key differences between Angular and AngularJS?
Angular
What is the purpose of NgModules in Angular?
Angular
How do you implement two-way data binding in Angular?
Angular
Explain the difference between services and directives in Angular.
Angular
What is lazy loading in Angular, and how is it implemented?
Angular
How do you handle state management in Angular applications?
Angular
What are Angular lifecycle hooks, and how are they used?
Angular
What is the difference between observable and promise in Angular?
Angular
How do you secure an Angular application?
Angular
How do you implement dependency injection in Angular?
SQL Server
What is the difference between a clustered and a non-clustered index in SQL Server?
SQL Server
How do you implement transactions in SQL Server, and what is their purpose?
SQL Server
Explain the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
SQL Server
What are stored procedures, and how are they different from functions?
SQL Server
How do you optimize SQL queries for better performance?
SQL Server
What are the differences between primary keys and foreign keys?
SQL Server
Explain the purpose of normalization and denormalization in database design.
SQL Server
How do you use CTE (Common Table Expressions) in SQL Server?
SQL Server
What is the purpose of the SQL Server Profiler, and how is it used?
SQL Server
What are indexes in SQL Server, and how do you maintain them?
Event Driven Archictechture
Azure Databus performance Improvement
Azure Fabrics
Azure highly available Database
Azure database
Azure Datafactory