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(1); // find student whose id = 1
                ctx.Students.Remove(std1);// remove student whose id = 1
                
                var std2 = ctx.Students.Find(2); // 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);
                }

            }
        }
    }