C# LINQ Join 쿼리 문법 (개발자를 위한 작동 원리)

LINQ Join 연산자의 문법

LINQ Join 연산자의 문법은 표현력이 뛰어나며 SQL 조인과 유사한 패턴을 따릅니다. 기본 문법은 다음과 같습니다:

var queryResult = 
    from element1 in collection1
    join element2 in collection2 on element1.Key equals element2.Key
    select new { element1, element2 };

var queryResult = 
    from element1 in collection1
    join element2 in collection2 on element1.Key equals element2.Key
    select new { element1, element2 };

Dim queryResult = From element1 In collection1
	Join element2 In collection2 On element1.Key Equals element2.Key
	Select New With {
		Key element1,
		Key element2
	}

이 문법에서:

• element1과 element2는 collection1과 collection2에서 요소를 나타내는 변수입니다.
• element1.Key와 element2.Key는 조인 작업의 기준으로 사용되는 속성입니다.
• equals 키워드는 조인의 조건을 지정합니다.
• select 절은 두 컬렉션의 요소를 결합한 새 객체를 생성합니다.

LINQ 조인의 유형

LINQ는 다음과 같은 여러 유형의 조인을 지원합니다:

1. Inner Join: 두 컬렉션에 일치하는 키가 있는 요소만 반환합니다.

   var innerJoin = from customer in customers
                   join order in orders on customer.CustomerID equals order.CustomerID // join orders to customers based on the customer ID key
                   select new { customer.CustomerID, customer.CustomerName, order.OrderID }; // create a new anonymous object based on the objects obtained from the join

   var innerJoin = from customer in customers
                   join order in orders on customer.CustomerID equals order.CustomerID // join orders to customers based on the customer ID key
                   select new { customer.CustomerID, customer.CustomerName, order.OrderID }; // create a new anonymous object based on the objects obtained from the join

   Dim innerJoin = From customer In customers ' create a new anonymous object based on the objects obtained from the join
   	Join order In orders On customer.CustomerID Equals order.CustomerID
   	Select New With {
   		Key customer.CustomerID,
   		Key customer.CustomerName,
   		Key order.OrderID
   	}

   $vbLabelText   $csharpLabel

2. Left Outer Join (기본값): 왼쪽 컬렉션의 모든 요소와 오른쪽 컬렉션의 일치하는 요소를 반환합니다. 일치하는 요소가 없을 경우 결과는 오른쪽 요소의 기본값을 포함합니다.

   var leftOuterJoin = from customer in customers
                       join order in orders on customer.CustomerID equals order.CustomerID into customerOrders
                       from co in customerOrders.DefaultIfEmpty()
                       select new { customer.CustomerID, customer.CustomerName, OrderID = co?.OrderID ?? -1 };

   var leftOuterJoin = from customer in customers
                       join order in orders on customer.CustomerID equals order.CustomerID into customerOrders
                       from co in customerOrders.DefaultIfEmpty()
                       select new { customer.CustomerID, customer.CustomerName, OrderID = co?.OrderID ?? -1 };

   Dim leftOuterJoin = From customer In customers
   	Group Join order In orders On customer.CustomerID Equals order.CustomerID Into customerOrders = Group
   	From co In customerOrders.DefaultIfEmpty()
   	Select New With {
   		Key customer.CustomerID,
   		Key customer.CustomerName,
   		Key .OrderID = If(co?.OrderID, -1)
   	}

   $vbLabelText   $csharpLabel

3. Group Join: 왼쪽 컬렉션의 요소를 오른쪽 컬렉션의 일치 요소와 그룹화합니다.

   var groupJoin = from customer in customers
                   join order in orders on customer.CustomerID equals order.CustomerID into customerOrders
                   select new { customer.CustomerID, customer.CustomerName, Orders = customerOrders };

   var groupJoin = from customer in customers
                   join order in orders on customer.CustomerID equals order.CustomerID into customerOrders
                   select new { customer.CustomerID, customer.CustomerName, Orders = customerOrders };

   Dim groupJoin = From customer In customers
   	Group Join order In orders On customer.CustomerID Equals order.CustomerID Into customerOrders = Group
   	Select New With {
   		Key customer.CustomerID,
   		Key customer.CustomerName,
   		Key .Orders = customerOrders
   	}

   $vbLabelText   $csharpLabel

IronPDF 설치: 빠른 시작

C# 프로젝트에서 IronPDF 라이브러리를 활용하려면 IronPDF NuGet 패키지를 쉽게 설치할 수 있습니다. 패키지 관리자 콘솔에서 다음 명령을 사용하십시오:

Install-Package IronPdf 

또한, NuGet 패키지 관리자에서 "IronPDF"를 검색하여 설치할 수 있습니다.

시나리오 1: PDF 생성 전에 데이터 결합

PDF 생성 프로세스를 시작하기 전에 여러 데이터 소스에서 데이터를 결합하는 것이 목표라면 LINQ Join을 독립적으로 사용할 수 있습니다. 통합된 데이터 세트가 완성되면 IronPDF를 이용하여 통합된 데이터를 기반으로 동적으로 PDF 문서를 생성할 수 있습니다.

여기 간단한 예제가 있습니다:

// Assume 'customerOrderInfo' is a result set obtained using LINQ Join
var pdfDocument = new IronPdf.ChromePdfRenderer();
foreach (var entry in customerOrderInfo)
{
    // Use IronPDF to add content to the PDF based on integrated data
    pdfDocument.AddHTML($"<p>Customer ID: {entry.CustomerID}, Order ID: {entry.OrderID}</p>");
}
// Save or render the PDF document as needed
pdfDocument.SaveAs("IntegratedDataDocument.pdf");

// Assume 'customerOrderInfo' is a result set obtained using LINQ Join
var pdfDocument = new IronPdf.ChromePdfRenderer();
foreach (var entry in customerOrderInfo)
{
    // Use IronPDF to add content to the PDF based on integrated data
    pdfDocument.AddHTML($"<p>Customer ID: {entry.CustomerID}, Order ID: {entry.OrderID}</p>");
}
// Save or render the PDF document as needed
pdfDocument.SaveAs("IntegratedDataDocument.pdf");

' Assume 'customerOrderInfo' is a result set obtained using LINQ Join
Dim pdfDocument = New IronPdf.ChromePdfRenderer()
For Each entry In customerOrderInfo
	' Use IronPDF to add content to the PDF based on integrated data
	pdfDocument.AddHTML($"<p>Customer ID: {entry.CustomerID}, Order ID: {entry.OrderID}</p>")
Next entry
' Save or render the PDF document as needed
pdfDocument.SaveAs("IntegratedDataDocument.pdf")

IronPDF 문서를 방문하여 PDF 문서 생성을 위한 더 많은 방법과 IronPDF와 함께 LINQ Join을 사용하는 방법을 탐색해 보세요.

시나리오 2: PDF 생성 중 동적 데이터 통합

IronPDF는 PDF 문서에 동적 콘텐츠 추가를 가능하게 하여 PDF 생성 프로세스 중 LINQ Join을 사용하여 데이터를 통합할 수 있습니다. 여기에서는 실제 적용 사례를 표현하기 위해 고객 클래스를 생성하고 정리할 것입니다. 데이터 소스는 SQL 데이터베이스나 몇 가지 구조화된 형식이 될 수 있으며, 이 경우 데이터 속성 세트를 포함한 객체의 리스트가 데이터베이스의 테이블처럼 존재합니다. 다음 예제는 PDF 생성을 위한 HTML 문자열을 사용하여 문서를 생성할 때 IronPDF와 함께 LINQ Join 메소드를 자세히 통합하는 방법을 보여줍니다:

using System;
using System.Collections.Generic;
using System.Linq;
using IronPdf;

class Order
{
    public int OrderID { get; set; }
    public int CustomerID { get; set; }
    // Other order-related properties...
}

class Customer
{
    public int CustomerID { get; set; }
    // Other customer-related properties...
}

class Program
{
    static void Main()
    {
        // Sample orders collection
        var orders = new List<Order>
        {
            new Order { OrderID = 1, CustomerID = 1 },
            new Order { OrderID = 2, CustomerID = 1 },
            new Order { OrderID = 3, CustomerID = 2 },
        };

        // Sample customers collection
        var customers = new List<Customer>
        {
            new Customer { CustomerID = 1 },
            new Customer { CustomerID = 2 },
        };

        var pdfDocument = new ChromePdfRenderer();
        string htmlContent = "<h1>Details generated using LINQ JOIN</h1>";

        // Use join to find customer orders
        var query = from customer in customers
                    join order in orders on customer.CustomerID equals order.CustomerID
                    select new { CustomerID = customer.CustomerID, OrderID = order.OrderID };

        foreach (var result in query)
        {
            // Use IronPDF to dynamically add content to the PDF based on integrated data
            htmlContent += $"<p>Customer ID: {result.CustomerID}, Order ID: {result.OrderID}</p>";
        }

        // Save or render the PDF document as needed
        pdfDocument.RenderHtmlAsPdf(htmlContent)
                   .SaveAs("DynamicIntegratedDataDocument.pdf");
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using IronPdf;

class Order
{
    public int OrderID { get; set; }
    public int CustomerID { get; set; }
    // Other order-related properties...
}

class Customer
{
    public int CustomerID { get; set; }
    // Other customer-related properties...
}

class Program
{
    static void Main()
    {
        // Sample orders collection
        var orders = new List<Order>
        {
            new Order { OrderID = 1, CustomerID = 1 },
            new Order { OrderID = 2, CustomerID = 1 },
            new Order { OrderID = 3, CustomerID = 2 },
        };

        // Sample customers collection
        var customers = new List<Customer>
        {
            new Customer { CustomerID = 1 },
            new Customer { CustomerID = 2 },
        };

        var pdfDocument = new ChromePdfRenderer();
        string htmlContent = "<h1>Details generated using LINQ JOIN</h1>";

        // Use join to find customer orders
        var query = from customer in customers
                    join order in orders on customer.CustomerID equals order.CustomerID
                    select new { CustomerID = customer.CustomerID, OrderID = order.OrderID };

        foreach (var result in query)
        {
            // Use IronPDF to dynamically add content to the PDF based on integrated data
            htmlContent += $"<p>Customer ID: {result.CustomerID}, Order ID: {result.OrderID}</p>";
        }

        // Save or render the PDF document as needed
        pdfDocument.RenderHtmlAsPdf(htmlContent)
                   .SaveAs("DynamicIntegratedDataDocument.pdf");
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Linq
Imports IronPdf

Friend Class Order
	Public Property OrderID() As Integer
	Public Property CustomerID() As Integer
	' Other order-related properties...
End Class

Friend Class Customer
	Public Property CustomerID() As Integer
	' Other customer-related properties...
End Class

Friend Class Program
	Shared Sub Main()
		' Sample orders collection
		Dim orders = New List(Of Order) From {
			New Order With {
				.OrderID = 1,
				.CustomerID = 1
			},
			New Order With {
				.OrderID = 2,
				.CustomerID = 1
			},
			New Order With {
				.OrderID = 3,
				.CustomerID = 2
			}
		}

		' Sample customers collection
		Dim customers = New List(Of Customer) From {
			New Customer With {.CustomerID = 1},
			New Customer With {.CustomerID = 2}
		}

		Dim pdfDocument = New ChromePdfRenderer()
		Dim htmlContent As String = "<h1>Details generated using LINQ JOIN</h1>"

		' Use join to find customer orders
		Dim query = From customer In customers
			Join order In orders On customer.CustomerID Equals order.CustomerID
			Select New With {
				Key .CustomerID = customer.CustomerID,
				Key .OrderID = order.OrderID
			}

		For Each result In query
			' Use IronPDF to dynamically add content to the PDF based on integrated data
			htmlContent &= $"<p>Customer ID: {result.CustomerID}, Order ID: {result.OrderID}</p>"
		Next result

		' Save or render the PDF document as needed
		pdfDocument.RenderHtmlAsPdf(htmlContent).SaveAs("DynamicIntegratedDataDocument.pdf")
	End Sub
End Class

이 코드는 각 고객에 대한 일치하는 주문을 찾는 데 도움을 주는 join 키워드를 사용하여 쿼리를 더 간결하고 표현력 있게 만듭니다.