public IEnumerable <Course> GetAllCourse() { using (var db = new ContosoDataDbContext()) { return(db.Courses.ToList()); } }
public IEnumerable <People> GetAllPeople() { using (var db = new ContosoDataDbContext()) { return(db.People.ToList()); } }
public Course GetCourseByTitle(string title) { using (var db = new ContosoDataDbContext()) { return(db.Courses.Where(d => d.Title == title).Single()); } }
public People GetPeopleByName(string FirstName) { using (var db = new ContosoDataDbContext()) { return(db.People.Where(d => d.FirstName == FirstName).SingleOrDefault()); } }
public Enrollments GetEnrollmentGrade(string Grade) { using (var db = new ContosoDataDbContext()) { return(db.Enrollment.Where(d => d.Grade == Grade).SingleOrDefault()); } }
public Courses GetCourseByName(string Title) { using (var db = new ContosoDataDbContext()) { return(db.Course.Where(d => d.Title == Title).SingleOrDefault()); } }
public Enrollment GetEnrollmentByGrade(string grade) { using (var db = new ContosoDataDbContext()) { return(db.Enrollments.Where(d => d.Grade == grade).FirstOrDefault()); } }
public IEnumerable <Enrollments> GetAllEnrollment() { using (var db = new ContosoDataDbContext()) { return(db.Enrollment.ToList()); } }
public Course GetHighestCredit() { using (var db = new ContosoDataDbContext()) { return(db.Courses.OrderByDescending(d => d.Credits).FirstOrDefault()); } }
public Enrollment GetEnrollmentById(int id) { using (var db = new ContosoDataDbContext()) { return(db.Enrollments.Where(d => d.Id == id).FirstOrDefault()); } }
public People GetPeopleByCity(string City) { using (var db = new ContosoDataDbContext()) { return(db.People.Where(d => d.City == City).Single()); } }
public People GetPeopleById(int id) { using (var db = new ContosoDataDbContext()) { return(db.People.Where(d => d.Id == id).FirstOrDefault()); } }
public Course GetCourseById(int id) { using (var db = new ContosoDataDbContext()) { return(db.Courses.Where(d => d.Id == id).FirstOrDefault()); } }
public void Create(People people) { using (var db = new ContosoDataDbContext()) { db.People.Add(people); db.SaveChanges(); } }
public Enrollments GetEnrollmentById(int id) { using (var db = new ContosoDataDbContext()) { var result = db.Enrollment.Where(d => d.Id == id).FirstOrDefault(); return(result); } }
public void Create(Enrollments enrollment) { using (var db = new ContosoDataDbContext()) { db.Enrollment.Add(enrollment); db.SaveChanges(); } }
public void Create(Course course) { using (var db = new ContosoDataDbContext()) { db.Courses.Add(course); db.SaveChanges(); } }
public Courses GetCourseById(int id) { using (var db = new ContosoDataDbContext()) { var result = db.Course.Where(d => d.Id == id).FirstOrDefault(); return(result); } }
public DepartmentRepository(ContosoDataDbContext context) : base(context) //access base class constructor { }
public DepartmentRepository(ContosoDataDbContext context) : base(context) { }
protected Repository(ContosoDataDbContext context) { _dbContext = context; }