Esempio n. 1
0
        static void Main(string[] args)
        {
            using (SchoolDataContext db = new SchoolDataContext())
            {
                Console.WriteLine("Enter a department name:");
                string dName = Console.ReadLine();
                Department department = new Department()
                {
                    Name = dName
                };
                db.Departments.Add(department);
                db.SaveChanges();

                Console.WriteLine("Enter a student information:");
                Student student = new Student {Department = department};
                Console.WriteLine("Write name: ");
                student.Name = Console.ReadLine();
                Console.WriteLine("Write address: ");
                student.Address = Console.ReadLine();
                Console.WriteLine("Write phone: ");
                student.Phone = Console.ReadLine();
                db.Students.Add(student);
                db.SaveChanges();
                DisplayStudents(db.Students.ToList());
            }

            Console.WriteLine("Done");
            Console.ReadLine();
        }
        static void Main(string[] args)
        {
            using (SchoolDataContext db = new SchoolDataContext())
            {
                Console.WriteLine("Update a new student. ");
                Student student = new Student();
                Console.WriteLine("Write the Id");
                student.StudentId = Convert.ToInt32(Console.ReadLine());
                //Console.WriteLine("Write name: ");
                //student.Name = Console.ReadLine();
                //Console.WriteLine("Write address: ");
                //student.Address = Console.ReadLine();
                //Console.WriteLine("Write phone: ");
                //student.Phone = Console.ReadLine();

                db.Students.Attach(student);
                db.Entry(student).State = EntityState.Deleted;
                db.SaveChanges();

                DisplayStudents(db.Students.ToList());
            }

            Console.WriteLine("Done");
            Console.ReadLine();
        }