public void RemoveAll()
{
using (StudentsEntities context = new StudentsEntities())
{
context.Database.ExecuteSqlCommand("TRUNCATE TABLE Students");
}
}
public void AddStudent(Student s)
{
using (StudentsEntities context = new StudentsEntities())
{
context.Students.Add(s);
context.SaveChanges();
}
}
public List <Student> GetStudents()
{
List <Student> result = new List <Student>();
using (StudentsEntities context = new StudentsEntities())
{
result = context.Students.ToList();
}
return(result);
}
public Student GetStudentById(string id)
{
Student result = new Student();
using (StudentsEntities context = new StudentsEntities())
{
result = context.Students.FirstOrDefault(s => s.Id == id);
}
return(result);
}
public void DeleteStudentById(string id)
{
using (StudentsEntities context = new StudentsEntities())
{
foreach (Student s in context.Students)
{
if (s.Id == id)
{
context.Students.Remove(s);
}
}
context.SaveChanges();
}
}