How to use Database connectivity with SQL Server for MVC.

This is very simple application to create a database using entity framework..
Create a model class named Student under Model folder and write the follwing code inside the model:



public class Student
{
public int StudentId {get;set;}
public string Name {get;set;}
public string Roll {get;set;}
public string Dept {get;set;}
}
public class StudentContext:DbContext
{
public DbSet Students {get;set;}
}

//Add a controller Named StudentController

public class StudentController:Controller
{
StudentContext db=new StudentContext();
public ActionResult AddStudent(Student student)
{
if(ModelState.isValid)
{
db.Students.add(student);
db.SaveChanges();
}
}
}

Now rebuild the project.Open the View folder.Right click on Student Folder.Select Add and then choose View.Give the view name AddStudent.Select Create template.Select model Student and choose database context s StudentContext.Click Add.You are done.Run your project.
This may help you.