How to pass data from controller to view? What is difference between viewbag, viewdata, tempdata. What is stored procedure? What is view? What is #tmp_table, ##tmp_table? What is routing?

Question

Accepted Answer

Explaining data passing, storage, and routing in Asp.Net Mvc.

Data can be passed from controller to view using ViewBag, ViewData, or TempData.
ViewBag is a dynamic property that allows passing data as key-value pairs.
ViewData is a dictionary object that stores data as key-value pairs.
TempData is a dictionary object that stores data for a single request and is cleared after that.
Stored procedure is a precompiled SQL code that can be executed multiple times.
View is a user interface element that displays data from the model.
#tmp_table is a temporary table that is created in the current session.
##tmp_table is a global temporary table that is created in the current database.
Routing is a mechanism that maps URLs to controller actions.
Routes can be defined in RouteConfig.cs file in App_Start folder.