Learn .Net MVC with Free Lessons & Tips

In simple few steps you can fill the dynamic data from database to HTML page in MVC Application 

1. Write connection string in web config file 
2. Create table related getter setter in model
3. Fetch data from db using SQL or MySQL reference 
4. Pass the list of data retried to controller 
5. Using jQuery ajax MVC call fill data to select tag of drop-down

Nowadays, we are using multiple core systems. We must write our .NET applications in such a way that we must utilise the complete computing power of the machine.

The parallel task library(TPL) allows you to write efficient code which is human readable, less error-prone and adjusts itself with the number of Cores available.

So your software would auto-upgrade with the upgrading environment.

It also improves the readability of the code and thus reduces the risk of getting bugs which makes solving difficult and time taking.

EXPLANATION
Restful service makes access to client information send to the server by JSON request that reduces several round trips from the server and hence optimises the speed.
HTML framework works the application MVC Web API with razor lack optimisation levels. The main reason is that razor methods lack optimisation levels of HTTP request-response communication between the client and the server. But by the implementation of json request behaviour, restful services get enabled that enables switching between client and servers much faster. Thus, faster the communication between client and the server.

CLR [ Common Language Runtime ] is one of the components of the .NET framework which provides an environment to execute the .NET code or the managed code. , CLR helps in converting the MSIL/CIL code into native code and running it.

Properties of CLR :

• Common Language Specification [ CLS]: a set of language rules, common to all the .NET supported programming languages.
• Common Type System [ CTS]: a data type system, familiar to all the .NET supported programming languages, which is further divided into value types and reference types
• Garbage Collector [ GC]: responsible for the "Automatic memory management."
• Just in Time [ JIT ] compiler: converts the MSIL/CIL code into native code

NOTE: we'll learn more about the CLR properties in the sessions.

Garbage collector [ GC ] is responsible for the "automatic memory management - AMM" in .NET framework. Garbage collector [ GC ] is one of the properties of .NET framework components CLR [ common language runtime ].

Why there is a need of "Memory management"?

Ans : Basically, Operating Sytem [ OS ] stores the data that is processed and accessed during programming / development of the applications in the memory. Sometimes that memory gets filled and developers may not be able to store the new data / input that is coming into. 

At this moment, developers need to write a seperate logic for the management of the memory, where they've to identify the unused or unnecessary data that has occupied the OS memory and need to write the logic for releasing that memory which is a burden for the developers.

Hence, to avoid the burden on the developers , this "automatic memory management" is needed.

In .NET, Garbage collector [ GC ] is responsible for the "automatic memory management" and it's popular for it's efficiency.

Working of Garbage collector [ GC ] : 

Garbage collector [ GC ] identifies the active and idled objects from the  heap memory , retains the active objects and destroys the idled objects and releases the memory. 

NOTE: GC provides automatic memory management only for "Reference types"

Generations of GC : 

Garbage collector [ GC ] divides the heap memory into 3 parts or generations and are named as Generation 0 , Generation 1 & Generation 2. Always Gen 0 > Gen 1 > Gen 2

Whenever a new object gets created , it occupies the memory only in Gen 0.

When Gen 0 gets filled completely, Garbage collector [ GC ] performs an action called "Collection" on Gen 0 , identifies the active and idled objects , pushes the active objects into Gen 1 and destroys the idled objects from the Gen 0 and releases the memory. 

When Gen 1 gets filled completely, Garbage collector [ GC ] performs an action called "Collection" on Gen 1 , identifies the active and idled objects , pushes the active objects into Gen 2 and destroys the idled objects from the Gen 1 and releases the memory. 

When Gen 2 gets filled completely, Garbage collector [ GC ] performs an action called "Collection" on Gen 2 , identifies the active and idled objects , retains the active objects and destroys the idled objects from the Gen 2 and releases the memory. 

Thus , Garbage collector [ GC ]  is efficient and responsible for "Automatic memory management" in .NET framework.

 public ActionResult Export()     {       StringBuilder sb = new StringBuilder();       //static file name, can be changes as per requirement       string sFileName = "filename.xls";       //Bind data list from edmx       var Data = objEntities.citymaster.Take(10).ToList();       if (Data != null && Data.Any())       {         sb.Append("<table style='1px solid black; font-size:12px;'>");         sb.Append("<tr>");         sb.Append("<td style='width:120px;'><b>City Name</b></td>");         sb.Append("<td style='width:300px;'><b>City Code</b></td>");         sb.Append("</tr>");         foreach (var result in Data)         {           sb.Append("<tr>");           sb.Append("<td>" + result.sCityName + "</td>");           sb.Append("<td>" + result.sCityCode + "</td>");           sb.Append("</tr>");         }       }       HttpContext.Response.AddHeader("content-disposition", "attachment; filename=" + sFileName);       this.Response.ContentType = "application/vnd.ms-excel";       byte[] buffer = System.Text.Encoding.UTF8.GetBytes(sb.ToString());       return File(buffer, "application/vnd.ms-excel");     }