ASP.NET 4.5 Architecture

Request Processing 

1. IIS gets the request
2. Looks up a script map extension and maps to aspnet_isapi.dll
3. Code hits the worker process (aspnet_wp.exe in IIS5 or w3wp.exe in IIS6)
4. .NET runtime is loaded
5. IsapiRuntime.ProcessRequest() called by non-managed code
6. IsapiWorkerRequest created once per request
7. HttpRuntime.ProcessRequest() called with Worker Request
8. HttpContext Object created by passing Worker Request as input
9. HttpApplication.GetApplicationInstance() called with Context to retrieve instance from pool
10. HttpApplication.Init() called to start pipeline event sequence and hook up modules and handlers
11. HttpApplicaton.ProcessRequest called to start processing
12. Pipeline events fire
13. Handlers are called and ProcessRequest method is fired
14. Control returns to pipeline and post request events fire

SQL : Sql Query Execution Order

Most programming languages executes set of statements from Top to Bottom but SQL Server executes set of statements in a logical order which is uniquely decides by the SQL Server in a predefined order known as Logical Query processing phase.

Introduction

When we are developing an application our concern mostly related to the code optimization which enhances the performance of application. When we are talking about an application it has broadly divided into two part one is the our code written in any programming language and other is the code written in database which executes at database level and return the results to our application.
In real world most application facing the performance issue which can be improved by code optimization. Here we will talk about the SQL query optimization.Most programming languages executes set of statements from Top to Bottom but SQL Server executes set of statements in a logical order which is uniquely decides by the SQL Server in a predefined order known as Logical Query processing phase.

C# : What is New in C# 6.0?

In this post we will see the newly added features in C# 6.0. In C# 6.0 some very cool features has been added like "Auto-property Enhancements", "Primary Constructors", "Expressions as Function Body", "Use of Static", "Exception Filters", "inline declarations", "nameof Expressions", "Null-conditional Operators", "String interpolation", "Await in catch and finally".

Introduction

Here, you will find nine new cool features of C# 6.0:

1. Auto-property Enhancements
2. Parameters on Classes and Structs
3. Using Static
4. Exception Filters
5. Null-conditional Operators
6. Index Initializers
7. $ sign
8. String Interpolation
9. nameof Expression
10. Await in catch and finally block