static void Main(string[] args) { StudentsContext context = new StudentsContext(); context.Students.Add(new Student { Name = "Petar", RegistrationDate = DateTime.Now }); context.SaveChanges(); }
static void Main(string[] args) { StudentsContext context = new StudentsContext(); Console.WriteLine("Lists of students and their homeworks:"); var studentHomeworks = context.Students.Select(s => new { StudentName = s.Name, StudentHomework = s.Homeworks }); foreach (var studentHomework in studentHomeworks) { Console.WriteLine(studentHomework.StudentName); foreach (var studentHW in studentHomework.StudentHomework) { int enumValue = (int)studentHW.ContentType; string stringValue = Enum.GetName(typeof(ContentType), enumValue); Console.WriteLine($"--HW-- {studentHW.Content} - {stringValue}"); } } Console.WriteLine("All courses and their resources:"); var coursesResources = context.Courses .OrderBy(c => c.StartDate) .ThenByDescending(c => c.EndDate) .Select(c => new { CourseName = c.Name, CourseDescription = c.Description, Resources = c.Resources }); foreach (var coursesResource in coursesResources) { Console.WriteLine(coursesResource.CourseName + " - " + coursesResource.CourseDescription); foreach (var resource in coursesResource.Resources) { Console.WriteLine($"--ResourceInfo-- {resource.Name} - {resource.URL}"); } } context.SaveChanges(); }