public List <Student> GetStudentByTeacherId(int teacherId)
{
using FineArtsContext context = new FineArtsContext();
//return context.Students.Where(t => t.TeacherId == teacherId).ToList();
//declarative using linQ
return((from s in context.Students
where s.TeacherId == teacherId
select s).ToList());
}
public bool HasTeaches()
{
//tradicional way
//FineArtsContext context = new FineArtsContext();
//bool result = context.Teachers.Any();
//context.Dispose();
//way with full using declaration
//bool result;
//using (FineArtsContext context = new FineArtsContext())
//{
// result = context.Teachers.Any();
//}
//return result;
//new short way
using FineArtsContext context = new FineArtsContext();
return(context.Teachers.Any());
}
public bool AddTeachers(Teacher[] teachers)
{
using FineArtsContext context = new FineArtsContext();
context.Teachers.AddRange(teachers);
return(context.SaveChanges() > 0);
}
public List <Teacher> GetTeachers()
{
using FineArtsContext context = new FineArtsContext();
return(context.Teachers.ToList());
}