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

Code First Approach - You just need to write a code in model after that database and tables will be created. I hope, you have added Entity Framework library in your application. Below is the example of first creating database by using "Code First Approach" after that you can easily do CRUD operation.

First create a model. 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; }
   }

Use below code in controller or in any .cs file to only create a database.

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