{ new Student { StudentID = 1, StudentName = "John" }

Download 48,5 Kb.
bet	3/4
Sana	15.12.2023
Hajmi	48,5 Kb.
	#119411

1 2 3 4

Bog'liq
Katta hajmli malumotlar
xudo xoxlasa tushadi99%, 3-labarotoriya ishi Saralash usul va algoritmlarini tadqiq qilis, cmd buyruqlari, Incremental model nima, 1matematik, word sAM 1 savol, Документ Microsoft Word (4), Ma\'ruzalar (2), ЛАБОРАТОРНАЯ РАБОТА N1, Dasturlash 2, Ariza, Qalandarova Gulshoda, 1648631455, 1650692784, 1651669892 (2)

// Qolgan kurslar... }; // Students va Courses jadvallarini INNER JOIN bilan boglash var query = from student in students
// Enrollments jadvali haqida malumotlar public static List EnrollmentsList = new List {
// Enrollment klassi class Enrollment { public int StudentID { get; set; }

{
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; }

Download 48,5 Kb.

1 2 3 4

Download 48,5 Kb.