public IEnumerable <Lecture> GetNoticeswithLectureName() //Student id
{
using (var context = new PenoContext())
{
var query = context.Lectures
.Include(q => q.Notices)
.ToList()
;
return(query);
}
}
public IEnumerable <Lecture> GetNotAndLecByStudentId(int id) //Student id
{
using (var context = new PenoContext())
{
var query = (from lec in context.Lectures
join las in context.LecAndStudents
on lec.Id equals las.LectureId
where las.StudentId == id
select lec).Include(q => q.Notices)
.ToList();
return(query);
}
}
