public void addStudent() { using (var db = new PupilEntities(String.Format(Properties.Settings.Default.PupilEntityFramework, Properties.Settings.Default.DesktopPupilConnection))) { Student student = new Student { IDNumber = "34", FirstName = "test", LastName = "test", DateCreated = DateTime.Now, DateModified = DateTime.Now, IsActive = true }; db.Students.Add(student); db.SaveChanges(); } }
public void addCourse() { var conn = String.Format(Properties.Settings.Default.PupilEntityFramework, Properties.Settings.Default.DesktopPupilConnection); using (var db = new PupilEntities(String.Format(Properties.Settings.Default.PupilEntityFramework, Properties.Settings.Default.DesktopPupilConnection))) { foreach (Course course in db.Courses) { db.Courses.Remove(course); } db.SaveChanges(); Course course1 = new Course { CourseNumber = "CS-200", Title = "Introduction to Java", Capacity = 35, DateCreated = DateTime.Now, DateModified = DateTime.Now, IsActive = true }; db.Courses.Add(course1); db.SaveChanges(); } }
public PupilController() { _context = new PupilEntities(Connections.PupilConnection); }