|
{
new Student { StudentID = 1, StudentName = "John" }
|
| bet | 3/4 | | Sana | 15.12.2023 | | Hajmi | 48,5 Kb. | | #119411 |
Bog'liq Katta hajmli malumotlar{
new Student { StudentID = 1, StudentName = "John" },
new Student { StudentID = 2, StudentName = "Alice" },
// Qolgan talabalar...
};
List courses = new List
{
new Course { CourseID = 101, CourseName = "Math" },
new Course { CourseID = 102, CourseName = "History" },
// Qolgan kurslar...
};
// Students va Courses jadvallarini INNER JOIN bilan bog'lash
var query = from student in students
join enrollment in Enrollments.EnrollmentsList on student.StudentID equals enrollment.StudentID
join course in courses on enrollment.CourseID equals course.CourseID
select new { student.StudentName, course.CourseName };
// Natijalarni chiqarish
foreach (var result in query)
{
Console.WriteLine($"Student: {result.StudentName}, Course: {result.CourseName}");
}
}
}
// Model klasslari
class Student
{
public int StudentID { get; set; }
public string StudentName { get; set; }
}
class Course
{
public int CourseID { get; set; }
public string CourseName { get; set; }
}
// Enrollment klassi
class Enrollments
{
// Enrollments jadvali haqida malumotlar
public static List EnrollmentsList = new List
{
new Enrollment { StudentID = 1, CourseID = 101 },
new Enrollment { StudentID = 2, CourseID = 102 },
// Qolgan o'quvchilar...
};
}
// Enrollment klassi
class Enrollment
{
public int StudentID { get; set; }
|
| |
