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(); }