How to connect to SQL Server using ASP.NET MVC web application?

The database and tables are created once you write a single line of code in the model. I assume your application includes the Entity Framework library. Here is an illustration of how to create a database utilizing the "Code First Approach" before moving on to simple CRUD operations.

Create a model first. Ex.

public class Person
    {
        [Key]
        public int Id{get;set;}
        [Required]
        public string name { get; set; }
        [Required]
        public string surname { get; set; }
    }

public class personContext : DbContext
    {
        public personContext()
            : base("EmploymentDbContext")
        {
            //If model change, It will re-create new database.
            Database.SetInitializer<personContext>(new DropCreateDatabaseIfModelChanges<personContext>());
        }
        public DbSet<Person> person { get; set; }
   }

To merely construct a database, place the following code in the controller or any other.cs file.

using (var ctx = new personContext())
            {
                ctx.Database.Create();
            }