MVC-SQL Database

MVC is one of three ASP.NET programming patterns.

MVC is a pattern for creating Web applications using MVC (Model View Controller model-view-controller) design:

Model (model) represents the core of the application (such as a database record list).

View displays data (database records).

Controller handles input (writes database records).

MVC pattern provides full control over HTML, CSS and JavaScript simultaneously.

MVC-SQL Database syntax

Visual Web Developer comes with a free SQL database called SQL Server Compact.

MVC-SQL Database example

<add name="MovieDBContext"
connectionString="Data Source=|DataDirectory|Movies.sdf"
providerName="System.Data.SqlServerCe.4.0"/>