Layout is the same as ASP.NET web form application Master page. When we need to more than one page contain common UI parts in our application such as the logo, heder, footer,Left navigation bar, right bar section in that case we should use to layout page in mvc application.

A view is like a virtual table. The Data is exposes is not stored in the view object itself. View are composed of sql queries that references tables and other view . but they are referenced just like tables in queries. Views serve two major purposes in sql server.

Action filter help you to preform logic while action method is executing and after action method executed. Some time we need to write pre and post processing logic from action method. for achieving this functionality ASP.NET MVC provides a feature called Filters.

View is a component of MVC framework . it is used to user interface view generally bind from the model data view have extensions like cshtml,vbhtml. My mvc application we had used views with controller to display data the end user. For rendering these static and dynamic content to the browser, MVC framework utilizes View Engines. View engines are used to finaly rendring the html to browser.

The Model-View-Controller (MVC) is design pattern that separates an application into three main component: model, view, and controller. Each of these component are built to manage particular section of an application. MVC is one of the most commonly used industry-standard web development framework to create scalable and extensible application.

Sql server support several types of objects that can be create within a sql database. SQL Server stores and manages data in its primary data structures , tables a table consist row and columns with data stored at the intersections of these rows and columns.