|
public int CourseID { get; set; }
|
| bet | 4/4 | | Sana | 15.12.2023 | | Hajmi | 48,5 Kb. | | #119411 |
Bog'liq Katta hajmli malumotlarpublic int CourseID { get; set; }
}
Left Join misoli:
using System;
using System.Collections.Generic;
using System.Linq;
class Program
{
static void Main()
{
// Students va Courses nomli ikkita ro'yxat
List students = new List
{
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 LEFT JOIN bilan bog'lash
var query = from student in students
join enrollment in Enrollments.EnrollmentsList on student.StudentID equals enrollment.StudentID into studentEnrollments
from enrollment in studentEnrollments.DefaultIfEmpty()
join course in courses on enrollment?.CourseID equals course.CourseID into studentCourses
from course in studentCourses.DefaultIfEmpty()
select new { student.StudentName, CourseName = course?.CourseName ?? "No Course" };
// Natijalarni chiqarish
foreach (var result in query)
{
Console.WriteLine($"Student: {result.StudentName}, Course: {result.CourseName}");
}
}
}
// Qolgan klasslar o'zgartirilmagan
Ushbu misollar INNER JOIN va LEFT JOIN amallarini ko'rsatish uchun. Bu misollar ma'lumotlar bazasidagi ma'lumotlar orasida bog'lashni o'rganishingizga yordam bera oladigan oddiy dasturlardir. O'zingizning ma'lumotlar bazangiz va talablaringizga mos ravishda ularni o'zgartiring.
|
| |
