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.

When I am working with MVC project I had a requirement like to clear all the errors and text entered inside a bootstrap modal. So that when I opened the modal again I could see a plain binding.

        $("#guest_form input[type='text'],input[type='password']").val('');  
        $("#guest_form input[type='text'],input[type='password']").each(function () {  
            $(this).removeClass('form-control input-validation-error');  
            $(this).addClass("form-control");  
        });  
        $(".field-validation-error").text('');  
    }); 

Initially my modal looks as follows

On submitting the modal without entering any data here my modal looks as follows

On closing the modal and opening it again I am still seeing the errors on my modal

What I need is I would like to clear all the validations and the classes which got applied using MVC validations so that it should again show me the original screen as follows

C# (Sharp) Syllabus: