ASP.NET MVC Developer Interview Questions and Answers

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 interfa...read more

Controller is a component in ASP.NET MVC that handles user requests, interacts with models, and returns appropriate views.

• Controller is responsible for receiving and processing user requests.

• It interacts with models to retrieve or update data.

• Controller determines which view to render and returns it to the user.

• It contains action methods that handle specific user actions.

• Controller can also perform validation and authentication tasks.

A subquery is a query nested inside another query, used to retrieve data from multiple tables or filter data based on a condition.

• A subquery is enclosed within parentheses and placed inside the WHERE or HAVING clause of the outer query.

• It is executed first and the result is used by the outer query.

• Subqueries can be used to perform calculations, filter data, or retrieve specific information from related tables.

• Example: SELECT * FROM Customers WHERE CustomerID IN (SELECT Custom...read more

A select query is used to retrieve data from a database table.

• Select query is a SQL statement used to fetch data from one or more tables.

• It specifies the columns to be retrieved and the table(s) from which to retrieve the data.

• The result of a select query is a result set that can be used for further processing or display.

• Example: SELECT * FROM Customers;

• Example: SELECT FirstName, LastName FROM Employees WHERE Age > 30;