private static List <Person> GetAllStudents()
{
using (SchoolModel schoolDb = new SchoolModel())
{
List <Person> people = schoolDb.People.Where(person => person.Discriminator == "Student").ToList();
return(people);
}
}
// Entity Framework
private static List <Person> GetPeople()
{
using (SchoolModel schoolDb = new SchoolModel())
{
List <Person> people = schoolDb.People.ToList();
return(people);
}
}
private static int GetTotalStudents()
{
using (SchoolModel schoolDb = new SchoolModel())
{
int total = schoolDb.People.Count(p => p.Discriminator == "Student");
return(total);
}
}
private static Person GetLopezSophia()
{
using (SchoolModel schoolDb = new SchoolModel())
{
Person person = schoolDb.People.FirstOrDefault(p => p.LastName == "Lopez" && p.FirstName == "Sophia");
return(person);
}
}
private static List <Course> GetAllCourses()
{
using (SchoolModel schoolDb = new SchoolModel())
{
List <Course> courses = schoolDb.Courses.ToList();
return(courses);
}
}
static void Main(string[] args)
{
List <Person> instructors = GetPeople();
//foreach (Person instructor in instructors)
//{
// Console.WriteLine(instructor.LastName + " " + instructor.FirstName);
//}
using (SchoolModel schoolDb = new SchoolModel())
{
//Person p = new Person();
//p.FirstName = "John";
//p.LastName = "Doe";
//p.Discriminator = "Student";
//p.EnrollmentDate = DateTime.Now;
//schoolDb.People.Add(p);
//schoolDb.SaveChanges();
Person liYan = schoolDb.People.FirstOrDefault(_ => _.LastName == "Li" && _.FirstName == "Yan");
if (liYan != null)
{
liYan.Discriminator = "Instructor";
schoolDb.SaveChanges();
}
bool johnDoeExists = schoolDb.People.Any(_ => _.LastName == "Doe" && _.FirstName == "John");
if (johnDoeExists)
{
Person johnDoe = schoolDb.People.First(_ => _.LastName == "Doe" && _.FirstName == "John");
schoolDb.People.Remove(johnDoe);
schoolDb.SaveChanges();
}
}
int totalStudents = GetTotalStudents();
Console.WriteLine(totalStudents);
Console.ReadKey();
}
