Setting up the environment:

To install EntityFramework 4.3.1, run following command in Package manager console (open VS2010, go to Tools → Library Package Manager → Package Manager Console):

This tutorial will use sample SchoolDB which has different tables, stored procedures and view.
Following is SchoolDB database design:

• One-to-One: Student and StudentAddress has one-to-one relationship eg. Student has zero or one StudentAddress.
• One-to-Many: Student and Teacher has one-to-many relationship eg. many Teachers can be associate with one Standard.
• Many-to-Many: Student and Course has many-to-many relationship using StudentCourse table where StudentCourse table includes StudentId and CourseId. So one student can join many courses and one course also can have many students.