using System.Data.Entity;

 class Program

 {

      static void  Main(string[] args)

      {

          using (var ctx = new SchoolDBEntities())

          {

                ctx.Students.Load();

                ctx.Students.Add(new Student() { StudentName = "New Student" });

                var std1 = ctx.Students.Find(); // find student whose id = 1

                ctx.Students.Remove(std1);// remove student whose id = 1

                var std2 = ctx.Students.Find(); // find student whose id = 1

                std2.StudentName = "Modified Name";

                // Loop over the students in context's local.

                Console.WriteLine("In Local: ");

                foreach (var student in ctx.Students.Local)

                {

                    Console.WriteLine("Found {0}: {1} with state {2}",

                                        student.StudentID, student.StudentName,

                                        ctx.Entry(student).State);

                }

                // Get all students from db.

                Console.WriteLine("\nIn DbSet query: ");

                foreach (var student in ctx.Students)

                {

                    Console.WriteLine("Found {0}: {1} with state {2}",

                                        student.StudentID, student.StudentName,

                                        ctx.Entry(student).State);

                }

          }

      }

 }