### Entity Framework Resources and Terminology

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/overview_source=recommendations

Provides access to Entity Framework resources, including library guidelines, terminology, and getting started guides.

```APIDOC
Entity Framework Resources:
  - Library Guidance: https://learn.microsoft.com/ko-kr/dotnet/standard/library-guidance/
  - Terminology: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/terminology
  - Getting Started: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/getting-started/
  - Language Reference: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/language-reference/
```

--------------------------------

### Launch 메서드: 설치 프로그램 실행 및 진행률 관찰 (C++)

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

지정된 설치 프로그램(.exe)을 실행하고 해당 프로세스의 진행률을 관찰합니다. CreateProcess를 사용하여 설치 프로그램을 시작하고, IProgressObserver 인터페이스를 통해 Run 메서드를 호출하여 진행률을 전달합니다.

```cpp
bool Launch(const CString& args)
{
CString cmdline = L"dotNetFx45_Full_x86_x64.exe -pipe TheSectionName " + args; // Customize with name and location of setup .exe that you want to run
STARTUPINFO si = {0};
si.cb = sizeof(si);
PROCESS_INFORMATION pi = {0};

// Launch the Setup.exe that installs the .NET Framework 4.5
BOOL bLaunchedSetup = ::CreateProcess(NULL,
 cmdline.GetBuffer(),
 NULL, NULL, FALSE, 0, NULL, NULL,
 &si,
 &pi);

// If successful
if (bLaunchedSetup != 0)
{
IProgressObserver& observer = dynamic_cast<IProgressObserver&>(*this);
Run(pi.hProcess, observer);

……………………..
return (bLaunchedSetup != 0);
}


```

--------------------------------

### Entity Framework Resources

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/how-to-make-model-and-mapping-files-embedded-resources_source=recommendations

Provides access to various resources for Entity Framework, including overview, modeling, querying, object manipulation, terminology, and getting started guides.

```APIDOC
Entity Framework Resources:
  - Overview: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/overview
  - Modeling and Mapping: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/modeling-and-mapping
  - How to: Make Model and Mapping Files Embedded Resources: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/how-to-make-model-and-mapping-files-embedded-resources
  - Working with Data Definition Language: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/working-with-data-definition-language
  - Querying a Conceptual Model: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/querying-a-conceptual-model
  - Working with Objects: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/working-with-objects
  - Entity Framework Resources: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/resources
  - Entity Framework Terminology: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/terminology
  - Getting Started: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/getting-started
  - Language Reference: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/ef/language-reference/
```

--------------------------------

### Server-Side Installer Initiation

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

This describes the typical server-side process for initiating the .NET Framework installer. The server creates a unique MMIO file name, uses `CreateProcess` to launch the redistributable, and passes the pipe name using the `-pipe` argument. The server's application UI code must implement the `OnProgress`, `Send`, and `Finished` methods.

```APIDOC
Server Initiation:
  1. Create a unique MMIO file name (e.g., using `Server::CreateSection`).
  2. Launch redistributable using `CreateProcess`.
  3. Pass pipe name with `-pipe someFileSectionName` argument.
  4. Implement `OnProgress`, `Send`, and `Finished` methods in application UI code.
```

--------------------------------

### Get Progress from .NET Installer

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

This section details how to retrieve progress information from the .NET installer. It is crucial for monitoring deployment status and providing user feedback during installation.

```APIDOC
APIDOC:
  GetDotNetInstallerProgress:
    description: Retrieves the current progress status of the .NET installer.
    parameters:
      None
    returns:
      progress_status: An object containing the current installation progress (e.g., percentage, current step).
      error: An error object if the progress could not be retrieved.
    example:
      # Pseudo-code example
      progress = GetDotNetInstallerProgress()
      print(f"Installation Progress: {progress.progress_status}")
```

--------------------------------

### InstallAware를 사용한 .NET Framework 포함

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers

InstallAware를 사용하여 설치 프로그램에 .NET Framework를 포함시키는 방법입니다. 기본 스크립트 편집 및 인증서 사전 설치를 통한 사용자 지정이 가능합니다.

```installaware
InstallAware는 단일 소스에서 Windows 앱(APPX), Windows Installer(MSI), 네이티브 코드(EXE) 및 App-V(Application Virtualization) 패키지를 빌드합니다. 설치 프로그램에 쉽게 [원하는 버전의 .NET Framework를 포함](https://www.installaware.com/one-click-pre-requisite-installer.htm)하여, 필요에 따라 [기본 스크립트를 편집](https://www.installaware.com/msicode.htm)함으로써 설치를 사용자 지정할 수 있습니다. 예를 들어 InstallAware는 Windows 7에 인증서를 미리 설치하여 .NET Framework 4.7 설치가 실패하지 않도록 방지합니다.
```

--------------------------------

### LINQ to SQL - Programming Guide

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/linq/how-to-directly-execute-sql-queries

A comprehensive guide to programming with LINQ to SQL, covering setup, data context, mapping, and querying.

```APIDOC
LINQ to SQL - Programming Guide:

This guide covers the essential aspects of using LINQ to SQL for data access in .NET applications. It includes information on:
- Setting up LINQ to SQL
- Working with the DataContext
- Object-Relational Mapping (ORM)
- Querying databases using LINQ syntax
- Handling data modifications (insert, update, delete)
- Error handling and best practices
```

--------------------------------

### .NET Framework 설치 연결 옵션

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers

애플리케이션의 사용자 지정 설치 프로그램에 .NET Framework 설치 프로세스를 연결(포함)하는 두 가지 UI 옵션입니다. 기본 UI 사용 또는 사용자 지정 UI 생성 방법을 설명합니다.

```installer
응용 프로그램의 사용자 지정 설치 프로그램을 만드는 경우 응용 프로그램의 설치 프로세스에 .NET Framework 설치 프로세스를 연결(포함)할 수 있습니다. 연결 시 .NET Framework 설치를 위해 두 개의 UI 옵션 제공:
  * .NET Framework 설치 관리자에 의해 제공된 기본 UI를 사용합니다.
  * 응용 프로그램의 설치 프로그램과 일관되도록 .NET Framework 설치용 사용자 지정 UI를 만듭니다.

두 방법 모두 웹 설치 관리자 또는 오프라인 설치 관리자를 사용할 수 있습니다.
```

--------------------------------

### LINQ to DataSet Programming

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/dataset-specific-operator-examples-linq-to-dataset_source=recommendations

Details on using LINQ to DataSet for querying and manipulating DataTables, including programming guides and examples.

```APIDOC
LINQ to DataSet:
  - Programming Guide: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/programming-guide-linq-to-dataset
  - Queries in LINQ to DataSet: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/queries-in-linq-to-dataset
  - Comparing DataRows: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/comparing-datarows-linq-to-dataset
  - Creating DataTable from Query: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/creating-a-datatable-from-a-query-linq-to-dataset
  - Implementing CopyToDataTable<T>: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/implement-copytodatatable-where-type-not-a-datarow
  - Generic Field and SetField Methods: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/generic-field-and-setfield-methods-linq-to-dataset
  - Debugging LINQ to DataSet Queries: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/debugging-linq-to-dataset-queries
  - Security: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/security-linq-to-dataset
  - Examples: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/linq-to-dataset-examples
    - DataSet-Specific Operator Examples: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/dataset-specific-operator-examples-linq-to-dataset
```

--------------------------------

### Main 함수: .NET Framework 4.5 설치 시작 (C++)

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

프로그램의 메인 진입점으로, 명령줄 인수를 처리하고 .NET Framework 4.5가 설치되어 있는지 확인한 후, 설치되어 있지 않으면 Server 클래스의 Launch 메서드를 호출하여 설치를 시작합니다.

```cpp
// Main entry point for program
int __cdecl main(int argc, _In_count_(argc) char **_argv)
{
    int result = 0;
    CString args;
    if (argc > 1)
    {
        args = CString(_argv[1]);
    }

    if (IsNetFx4Present(NETFX45_RC_REVISION))
    {
        printf(".NET Framework 4.5 is already installed");
    }
    else
    {
        result = Server().Launch(args);
    }

    return result;
}


```

--------------------------------

### .NET Framework 4.5 설치 프로그램 호출 및 MMIO 섹션에서 진행률 정보 받기

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer

이 코드는 .NET Framework 4.5 재배포 가능 프로그램을 호출하고 MMIO 섹션에서 진행률 정보를 받는 방법을 보여줍니다. 설치 프로그램은 MMIO 섹션을 읽고 비동기적으로 쓰므로 이벤트 및 메시지를 사용하는 것이 편리할 수 있습니다. 이 예제에서는 MMIO 섹션과 이벤트를 정의하는 생성자를 사용하여 .NET Framework 4.5 설치 프로세스를 만듭니다.

```cpp
Server():ChainerSample::MmioChainer(L"TheSectionName", L"TheEventName")
```

--------------------------------

### Service Disabled Exception Example

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/samples/net-tcp-port-sharing-sample

This code snippet shows an example of an unhandled exception that occurs when the NetTcpPortSharing service is disabled. The exception indicates that the service failed to start because it is disabled, and an administrator needs to enable it.

```C#
Unhandled Exception: System.ServiceModel.CommunicationException: The TransportManager failed to listen on the supplied URI using the NetTcpPortSharing service: failed to start the service because it is disabled. An administrator can enable it by running 'sc.exe config NetTcpPortSharing start= demand'. ---> System.InvalidOperationException: Cannot start service NetTcpPortSharing on computer '.'. ---> System.ComponentModel.Win32Exception: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it

```

--------------------------------

### Generative AI in .NET

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/windows-workflow-foundation/samples/using-the-pick-activity

Resources for developing generative AI applications using .NET, including guides and examples.

```AI
https://learn.microsoft.com/ko-kr/dotnet/ai/
```

--------------------------------

### InstallAware를 사용한 .NET Framework 배포

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers_source=recommendations

InstallAware를 사용하여 .NET Framework를 설치 프로그램에 포함하고 설치 환경을 사용자 지정하는 방법을 설명합니다.

```text
InstallAware는 단일 소스에서 Windows 앱(APPX), Windows Installer(MSI), 네이티브 코드(EXE) 및 App-V(Application Virtualization) 패키지를 빌드합니다. 설치 프로그램에 쉽게 [원하는 버전의 .NET Framework를 포함](https://www.installaware.com/one-click-pre-requisite-installer.htm)하여, 필요에 따라 [기본 스크립트를 편집](https://www.installaware.com/msicode.htm)함으로써 설치를 사용자 지정할 수 있습니다.
```

--------------------------------

### .NET Framework 배포 프로세스 설명

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/guide-for-administrators

Configuration Manager를 사용하여 .NET Framework 재배포 가능 패키지를 네트워크 상의 컴퓨터에 배포하는 프로세스를 설명합니다. 컬렉션, 패키지 및 프로그램, 배포 지점, 배포의 5가지 주요 영역을 포함합니다.

```ko-kr
컬렉션: .NET Framework가 배포되는 대상인 사용자, 사용자 그룹, 컴퓨터와 같은 Configuration Manager 리소스 그룹입니다.
패키지 및 프로그램: 클라이언트 컴퓨터에 설치할 소프트웨어 애플리케이션, 개별 파일, 업데이트 또는 명령을 나타냅니다.
배포 지점: 클라이언트 컴퓨터에서 실행할 소프트웨어에 필요한 파일을 저장하는 Configuration Manager 사이트 시스템 역할입니다.
배포: 지정된 대상 컬렉션의 멤버에게 소프트웨어 패키지를 설치하라고 지시합니다.
```

--------------------------------

### .NET Data Access Documentation

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/windows-workflow-foundation/flowchart-workflows

Guides and examples for accessing and managing data within .NET applications.

```APIDOC
See .NET Data Access documentation: https://learn.microsoft.com/ko-kr/dotnet/navigate/data-access/
```

--------------------------------

### Troubleshooting WCF Setup Issues

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/specifying-and-handling-faults-in-contracts-and-services_source=recommendations

Guidance for resolving WCF installation problems.

```APIDOC
https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/troubleshooting-setup-issues
```

--------------------------------

### Launch 메서드: 설치 프로그램 실행 및 진행률 관찰 (C++)

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer

지정된 설치 프로그램(.exe)을 실행하고 해당 프로세스의 진행률을 관찰합니다. CreateProcess를 사용하여 설치 프로그램을 시작하고, IProgressObserver 인터페이스를 통해 Run 메서드를 호출하여 진행률을 전달합니다.

```cpp
bool Launch(const CString& args)
{
CString cmdline = L"dotNetFx45_Full_x86_x64.exe -pipe TheSectionName " + args; // Customize with name and location of setup .exe that you want to run
STARTUPINFO si = {0};
si.cb = sizeof(si);
PROCESS_INFORMATION pi = {0};

// Launch the Setup.exe that installs the .NET Framework 4.5
BOOL bLaunchedSetup = ::CreateProcess(NULL,
 cmdline.GetBuffer(),
 NULL, NULL, FALSE, 0, NULL, NULL,
 &si,
 &pi);

// If successful
if (bLaunchedSetup != 0)
{
IProgressObserver& observer = dynamic_cast<IProgressObserver&>(*this);
Run(pi.hProcess, observer);

……………………..
return (bLaunchedSetup != 0);
}


```

--------------------------------

### WCF Diagnostics and Troubleshooting

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/how-to-restrict-access-with-the-principalpermissionattribute-class_source=recommendations

Guides for troubleshooting WCF issues, managing diagnostics, and resolving setup problems.

```APIDOC
WCF Diagnostics and Troubleshooting:
  WCF Troubleshooting Quickstart: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/wcf-troubleshooting-quickstart
  WCF Error Handling: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/wcf-error-handling
  Management and Diagnostics: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/diagnostics/
  Operating System Resources Required by WCF: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/operating-system-resources-required-by-wcf
  Troubleshooting Setup Issues: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/troubleshooting-setup-issues
```

--------------------------------

### .NET Framework 구성 스키마: startup 요소

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/configure-apps/file-schema/startup/startup-element

이것은 .NET Framework 애플리케이션의 시작 구성을 위한 XML 스키마입니다. useLegacyV2RuntimeActivationPolicy 특성을 사용하여 레거시 런타임 활성화 정책을 제어할 수 있습니다.

```APIDOC
<configuration>
  <startup useLegacyV2RuntimeActivationPolicy="true|false" >
    <supportedRuntime version=".NET Framework 4.0" />
    <supportedRuntime version="v2.0.50727" />
  </startup>
</configuration>

startup 요소:
  useLegacyV2RuntimeActivationPolicy: 선택적 특성입니다. .NET Framework 2.0 런타임 활성화 정책을 사용할지 또는 .NET Framework 4 활성화 정책을 사용할지 지정합니다.
    true: 선택한 런타임에 대해 .NET Framework 2.0 런타임 활성화 정책을 사용하도록 설정합니다.
    false: .NET Framework 4 이상에 대한 기본 활성화 정책을 사용합니다. 이 값은 기본값입니다.
  supportedRuntime: 애플리케이션이 지원하는 공용 언어 런타임 버전을 지정합니다.
```

--------------------------------

### WCF Troubleshooting Quickstart

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/specifying-and-handling-faults-in-contracts-and-services_source=recommendations

A quick guide to troubleshooting common WCF issues.

```APIDOC
https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/wcf-troubleshooting-quickstart
```

--------------------------------

### .NET Framework 4.5 존재 확인 함수 (C++)

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

지정된 최소 릴리스 버전을 기준으로 .NET Framework 4.x의 존재 여부를 확인하는 함수입니다. 레지스트리에서 'Release' 값을 쿼리하여 버전을 확인하며, 4.0의 경우 'Install' 값을 확인합니다.

```cpp
///  Checks for presence of the .NET Framework 4.
///    A value of 0 for dwMinimumRelease indicates a check for the .NET Framework 4 full
///    Any other value indicates a check for a specific compatible release of the .NET Framework 4.
#define NETFX40_FULL_REVISION 0
// TODO: Replace with released revision number
#define NETFX45_RC_REVISION MAKELONG(50309, 5)   // .NET Framework 4.5
bool IsNetFx4Present(DWORD dwMinimumRelease)
{
    DWORD dwError = ERROR_SUCCESS;
    HKEY hKey = NULL;
    DWORD dwData = 0;
    DWORD dwType = 0;
    DWORD dwSize = sizeof(dwData);

    dwError = ::RegOpenKeyExW(HKEY_LOCAL_MACHINE, L"SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full", 0, KEY_READ, &hKey);
    if (ERROR_SUCCESS == dwError)
    {
        dwError = ::RegQueryValueExW(hKey, L"Release", 0, &dwType, (LPBYTE)&dwData, &dwSize);

        if ((ERROR_SUCCESS == dwError) && (REG_DWORD != dwType))
        {
            dwError = ERROR_INVALID_DATA;
        }
        else if (ERROR_FILE_NOT_FOUND == dwError)
        {
            // Release value was not found, let's check for 4.0.
            dwError = ::RegQueryValueExW(hKey, L"Install", 0, &dwType, (LPBYTE)&dwData, &dwSize);

            // Install = (REG_DWORD)1;
            if ((ERROR_SUCCESS == dwError) && (REG_DWORD == dwType) && (dwData == 1))
            {
                // treat 4.0 as Release = 0
                dwData = 0;
            }
            else
            {
                dwError = ERROR_INVALID_DATA;
            }
        }
    }

    if (hKey != NULL)
    {
        ::RegCloseKey(hKey);
    }

    return ((ERROR_SUCCESS == dwError) && (dwData >= dwMinimumRelease));
}


```

--------------------------------

### .NET Framework 설치 관련 오류 코드 링크

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/guide-for-administrators

.NET Framework 설치 중 발생할 수 있는 다양한 오류 코드에 대한 추가 정보를 얻을 수 있는 외부 리소스 링크입니다. BITS, URL 모니커, WinHttp, Windows Installer 및 Windows 업데이트 에이전트 관련 오류 코드를 포함합니다.

```APIDOC
추가 오류 코드 정보:

* [BITS(Background Intelligent Transfer Service) 오류 코드](https://learn.microsoft.com/ko-kr/windows/desktop/Bits/bits-return-values)
* [URL 모니커 오류 코드](https://learn.microsoft.com/ko-kr/previous-versions/windows/internet-explorer/ie-developer/platform-apis/ms775145(v=vs.85))
* [WinHttp 오류 코드](https://learn.microsoft.com/ko-kr/windows/desktop/WinHttp/error-messages)
* [Windows Installer 오류 코드](https://learn.microsoft.com/ko-kr/windows/desktop/msi/error-codes)
* [Windows 업데이트 에이전트 결과 코드](https://learn.microsoft.com/ko-kr/previous-versions/windows/it-pro/windows-server-2008-R2-and-2008/cc720442(v=ws.10))
```

--------------------------------

### VB.NET SqlBulkCopy Setup and Data Insertion

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/multiple-bulk-copy-operations_source=recommendations

This VB.NET example illustrates the setup and execution of SqlBulkCopy. It includes opening a SqlConnection, clearing existing data from destination tables, performing initial row counts, and preparing a SqlCommand to select source data with a parameter.

```VB.NET
Imports System.Data.SqlClient

Module Module1
    Sub Main()
        Dim connectionString As String = GetConnectionString()

        ' Open a connection to the AdventureWorks database.
        Using connection As SqlConnection = New SqlConnection(connectionString)
            connection.Open()

            ' Empty the destination tables.
            Dim deleteHeader As New SqlCommand( _
              "DELETE FROM dbo.BulkCopyDemoOrderHeader;", connection)
            deleteHeader.ExecuteNonQuery()
            deleteHeader.Dispose()
            Dim deleteDetail As New SqlCommand( _
              "DELETE FROM dbo.BulkCopyDemoOrderDetail;", connection)
            deleteDetail.ExecuteNonQuery()

            ' Perform an initial count on the destination table
            ' with matching columns.
            Dim countRowHeader As New SqlCommand( _
               "SELECT COUNT(*) FROM dbo.BulkCopyDemoOrderHeader;", _
                connection)
            Dim countStartHeader As Long = System.Convert.ToInt32( _
             countRowHeader.ExecuteScalar())
            Console.WriteLine("Starting row count for Header table = {0}", _
             countStartHeader)

            ' Perform an initial count on the destination table
            ' with different column positions.
            Dim countRowDetail As New SqlCommand( _
                "SELECT COUNT(*) FROM dbo.BulkCopyDemoOrderDetail;", _
                connection)
            Dim countStartDetail As Long = System.Convert.ToInt32( _
                countRowDetail.ExecuteScalar())
            Console.WriteLine("Starting row count for Detail table = " & _
               countStartDetail)

            ' Get data from the source table as a SqlDataReader.
            ' The Sales.SalesOrderHeader and Sales.SalesOrderDetail
            ' tables are quite large and could easily cause a timeout
            ' if all data from the tables is added to the destination.
            ' To keep the example simple and quick, a parameter is
            ' used to select only orders for a particular account as
            ' the source for the bulk insert.
            Dim headerData As SqlCommand = New SqlCommand( _
             "SELECT [SalesOrderID], [OrderDate], " & _
             "[AccountNumber] FROM [Sales].[SalesOrderHeader] " & _
             "WHERE [AccountNumber] = @accountNumber;", _
             connection)

            Dim parameterAccount As SqlParameter = New SqlParameter()
            parameterAccount.ParameterName = "@accountNumber"
            parameterAccount.SqlDbType = SqlDbType.NVarChar
            parameterAccount.Direction = ParameterDirection.Input
            parameterAccount.Value = "10-4020-000034"
            headerData.Parameters.Add(parameterAccount)
            ' ... (rest of the code for writing data would follow) ...
        End Using ' connection
    End Sub
End Module

```

--------------------------------

### 클라이언트 애플리케이션을 사용하여 .NET Framework 배포

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment_source=recommendations

클라이언트 애플리케이션을 사용하여 .NET Framework를 배포하는 방법에 대한 정보를 제공합니다. InstallShield, Visual Studio ClickOnce, WiX 및 사용자 지정 설치 관리자 사용에 대한 링크를 포함합니다.

```ko-kr
클라이언트 애플리케이션을 사용하여 .NET Framework 배포(개발자용):
  * 설치 및 배포 프로젝트에서 [InstallShield 사용](https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers#installshield-deployment)
  * [Visual Studio ClickOnce 애플리케이션 사용](https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers#clickonce-deployment)
  * [WiX 설치 패키지 만들기](https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers#wix)
  * [사용자 지정 설치 관리자 사용](https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers#chaining)
  * 개발자를 위한 [추가 정보](https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers)
```

--------------------------------

### .NET Framework Troubleshooting

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/dataset-specific-operator-examples-linq-to-dataset_source=recommendations

Links to troubleshooting guides for .NET development issues.

```APIDOC
Troubleshooting:
  - Welcome to .NET Troubleshooting: https://learn.microsoft.com/ko-kr/troubleshoot/developer/dotnet/welcome-dotnet-landing
```

--------------------------------

### VB.NET SqlBulkCopy Setup and Data Insertion

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/multiple-bulk-copy-operations

This VB.NET example illustrates the setup and execution of SqlBulkCopy. It includes opening a SqlConnection, clearing existing data from destination tables, performing initial row counts, and preparing a SqlCommand to select source data with a parameter.

```VB.NET
Imports System.Data.SqlClient

Module Module1
    Sub Main()
        Dim connectionString As String = GetConnectionString()

        ' Open a connection to the AdventureWorks database.
        Using connection As SqlConnection = New SqlConnection(connectionString)
            connection.Open()

            ' Empty the destination tables.
            Dim deleteHeader As New SqlCommand( _
              "DELETE FROM dbo.BulkCopyDemoOrderHeader;", connection)
            deleteHeader.ExecuteNonQuery()
            deleteHeader.Dispose()
            Dim deleteDetail As New SqlCommand( _
              "DELETE FROM dbo.BulkCopyDemoOrderDetail;", connection)
            deleteDetail.ExecuteNonQuery()

            ' Perform an initial count on the destination table
            ' with matching columns.
            Dim countRowHeader As New SqlCommand( _
               "SELECT COUNT(*) FROM dbo.BulkCopyDemoOrderHeader;", _
                connection)
            Dim countStartHeader As Long = System.Convert.ToInt32( _
             countRowHeader.ExecuteScalar())
            Console.WriteLine("Starting row count for Header table = {0}", _
             countStartHeader)

            ' Perform an initial count on the destination table
            ' with different column positions.
            Dim countRowDetail As New SqlCommand( _
                "SELECT COUNT(*) FROM dbo.BulkCopyDemoOrderDetail;", _
                connection)
            Dim countStartDetail As Long = System.Convert.ToInt32( _
                countRowDetail.ExecuteScalar())
            Console.WriteLine("Starting row count for Detail table = " & _
               countStartDetail)

            ' Get data from the source table as a SqlDataReader.
            ' The Sales.SalesOrderHeader and Sales.SalesOrderDetail
            ' tables are quite large and could easily cause a timeout
            ' if all data from the tables is added to the destination.
            ' To keep the example simple and quick, a parameter is
            ' used to select only orders for a particular account as
            ' the source for the bulk insert.
            Dim headerData As SqlCommand = New SqlCommand( _
             "SELECT [SalesOrderID], [OrderDate], " & _
             "[AccountNumber] FROM [Sales].[SalesOrderHeader] " & _
             "WHERE [AccountNumber] = @accountNumber;", _
             connection)

            Dim parameterAccount As SqlParameter = New SqlParameter()
            parameterAccount.ParameterName = "@accountNumber"
            parameterAccount.SqlDbType = SqlDbType.NVarChar
            parameterAccount.Direction = ParameterDirection.Input
            parameterAccount.Value = "10-4020-000034"
            headerData.Parameters.Add(parameterAccount)
            ' ... (rest of the code for writing data would follow) ...
        End Using ' connection
    End Sub
End Module

```

--------------------------------

### 설치 취소 플래그

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

MMIO 섹션에 `m_downloadAbort` 및 `m_installAbort` 플래그를 설정하여 .NET Framework 4.5 설치를 취소할 수 있습니다. 이 플래그는 `Abort` 메서드를 통해 설정됩니다.

```APIDOC
설치 취소:
  언제든지 `Abort` 메서드를 통해 MMIO 섹션에 `m_downloadAbort` 및 `m_ installAbort` 플래그를 설정하여 설치를 취소할 수 있습니다.
```

--------------------------------

### .NET Framework 4.5 설치 프로그램 호출

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

.NET Framework 4.5 설치 프로그램을 호출하고 MMIO 섹션에서 진행률 정보를 받기 위한 명령줄 인수입니다. `/q`는 자동 설치를, `/norestart`는 재시작 방지를, `/pipe section-name`은 통신할 섹션 이름을 지정합니다.

```bash
dotNetFx45_Full_x86_x64.exe /q /norestart /pipe section-name
```

--------------------------------

### Related .NET Framework Resources

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/install/guide-for-developers_source=recommendations

This section lists various guides and articles related to .NET Framework, including deployment, installation, troubleshooting, and system requirements.

```APIDOC
APIDOC:
  title: Deployment Guide for Developers
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers

  title: Deployment Guide for Administrators
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/guide-for-administrators

  title: Installing .NET Framework 3.5 on Windows 11, Windows 10, Windows 8.1, and Windows 8
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/install/dotnet-35-windows

  title: Troubleshoot blocked .NET Framework installations and uninstallations
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/install/troubleshoot-blocked-installations-and-uninstallations

  title: .NET Framework System Requirements
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/get-started/system-requirements

  title: Problems running programs after an upgrade - .NET Framework
  url: https://learn.microsoft.com/ko-kr/troubleshoot/developer/dotnet/framework/installation/cannot-run-programs-after-upgrade

  title: Repair .NET Framework
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/install/repair

  title: Install .NET Framework on Windows and Server
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/install/on-windows-and-server

  title: Get started with .NET Framework
  url: https://learn.microsoft.com/ko-kr/dotnet/framework/get-started/
```

--------------------------------

### WiX(Windows Installer XML)를 사용한 .NET Framework 배포

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/deployment-guide-for-developers_source=recommendations

WiX 도구 집합을 사용하여 XML 소스 코드에서 Windows 설치 패키지를 빌드하고 .NET Framework를 필수 조건으로 지정하는 방법을 설명합니다.

```xml
WiX를 사용하여 .NET Framework 배포 환경을 완벽하게 제어하기 위해 [.NET Framework를 필수 조건으로 지정](https://wixtoolset.org/documentation/manual/v3/howtos/redistributables_and_install_checks/install_dotnet.html)하거나 [chainer를 만들](https://wixtoolset.org/documentation/manual/v3/xsd/wix/exepackage.html) 수 있습니다.
```

--------------------------------

### LINQ to DataSet

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/loading-data-into-a-dataset

Documentation for LINQ to DataSet, including getting started, overview, loading data into DataSets, creating projects in Visual Studio, and downloading sample databases.

```APIDOC
LINQ to DataSet:
  Getting Started: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/getting-started-linq-to-dataset
  Overview: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/linq-to-dataset-overview
  Loading Data into a DataSet: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/loading-data-into-a-dataset
  How to: Create a LINQ to DataSet Project in Visual Studio: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/how-to-create-a-linq-to-dataset-project-in-vs
  Downloading Sample Databases: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/downloading-sample-databases-linq-to-dataset
```

--------------------------------

### WCF 샘플 애플리케이션 다운로드

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/getting-started-tutorial_source=recommendations

Windows Communication Foundation 샘플 애플리케이션을 다운로드하고 실행할 수 있습니다. 샘플에 대한 소개는 Getting started sample을 참조하세요.

```link
https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/samples/
```

--------------------------------

### Microsoft Learn Topics

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/how-to-get-progress-from-the-dotnet-installer_source=recommendations

Links to documentation and resources covering various technical topics and domains on Microsoft Learn.

```APIDOC
APIDOC:
  LearnTopics:
    Organizations: https://learn.microsoft.com/ko-kr/training/organizations/
    Artificial Intelligence: https://learn.microsoft.com/ko-kr/ai/
    Compliance: https://learn.microsoft.com/ko-kr/compliance/
    DevOps: https://learn.microsoft.com/ko-kr/devops/
    Platform Engineering: https://learn.microsoft.com/ko-kr/platform-engineering/
    Security: https://learn.microsoft.com/ko-kr/security/
```

--------------------------------

### LINQ to DataSet Programming Guide

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/linq-to-dataset-examples

Details on how to use LINQ to DataSet for querying DataTables. Includes examples for comparing DataRows, creating DataTables from queries, implementing generic methods, and debugging.

```APIDOC
LINQ to DataSet:
  Programming Guide:
    - Querying in LINQ to DataSet
    - Comparing DataRows
    - Creating a DataTable from a Query
    - Implementing CopyToDataTable<T>
    - Generic Field and SetField Methods
    - Debugging LINQ to DataSet Queries
    - Security
    - Examples:
      - DataSet-Specific Operator Examples
```

--------------------------------

### F# 프로그래밍 언어

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/guide-for-administrators

F#은 .NET 플랫폼을 위한 함수형 프로그래밍 언어입니다. 간결하고 강력한 구문으로 복잡한 문제를 해결하는 데 효과적입니다.

```F#
printfn "Hello, World!"
```

--------------------------------

### Visual Basic 프로그래밍 언어

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/guide-for-administrators

Visual Basic은 .NET 플랫폼을 위한 객체 지향 프로그래밍 언어입니다. 배우기 쉽고 생산성이 높아 다양한 애플리케이션 개발에 널리 사용됩니다.

```Visual Basic
Module Module1

    Sub Main()
        Console.WriteLine("Hello, World!")
    End Sub

End Module
```

--------------------------------

### Windows Communication Foundation (WCF) Samples

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/wcf/samples/behaviors

This section provides various samples for Windows Communication Foundation (WCF), covering basic samples, getting started, services, and configuration.

```APIDOC
Windows Communication Foundation (WCF) Samples:

Basic Sample:
  Description: Demonstrates fundamental WCF concepts.

Getting Started Sample:
  Description: Provides a starting point for WCF development.

Services:
  Concurrency:
    Description: Samples related to managing concurrency in WCF services.
  Default Service Behavior:
    Description: Samples illustrating default behaviors for WCF services.
  Instancing:
    Description: Samples related to service instancing in WCF.
  Metadata Publishing Behavior:
    Description: Samples for configuring metadata publishing in WCF services.
  Service Transaction Behavior:
    Description: Samples demonstrating transaction management in WCF services.
  Service Debug Behavior:
    Description: Samples for debugging WCF services.
  Throttling:
    Description: Samples related to controlling the rate of service operations.

Simplified Configuration for WCF Services:
  Description: Demonstrates how to simplify configuration for WCF services.

Usage of Standard Endpoints:
  Description: Samples showing the use of standard endpoints in WCF.

Extended Protection Policy:
  Description: Samples related to extended protection policies in WCF.

Configuration Channel Factory:
  Description: Samples for creating channel factories using configuration.

Addressing:
  Description: Samples related to addressing in WCF.

Imperative:
  Description: Samples demonstrating imperative WCF configuration.

Multiple Contracts:
  Description: Samples showing how to use multiple contracts in WCF services.

Multiple Endpoints:
  Description: Samples illustrating the use of multiple endpoints in WCF services.

Multiple Endpoints at a Single ListenUri:
  Description: Samples for hosting multiple endpoints at a single ListenUri.

OperationContextScope:
  Description: Samples demonstrating the use of OperationContextScope in WCF.

Service Description:
  Description: Samples related to describing WCF services.

ConcurrencyMode.Reentrant:
  Description: Samples specifically for ConcurrencyMode.Reentrant in WCF.
```

--------------------------------

### .NET Framework 4.5 패키지 배포 단계

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/deployment/guide-for-administrators

Configuration Manager 콘솔을 사용하여 .NET Framework 4.5 패키지를 대상 컬렉션에 배포하는 단계별 절차입니다. 소프트웨어 라이브러리에서 패키지를 선택하고 배포 마법사를 통해 설정을 구성합니다.

```APIDOC
Configuration Manager 콘솔을 사용한 .NET Framework 4.5 패키지 배포:

1. **소프트웨어 라이브러리** > **애플리케이션 관리** > **패키지** 선택.
2. **.NET Framework 4.5** 패키지 선택.
3. **홈** 탭에서 **배포** 선택.
4. **소프트웨어 배포 마법사**:
   - **일반**: 컬렉션 선택.
   - **콘텐츠**: 배포 시작 지점 확인.
   - **배포 설정**: 작업 '설치', 용도 '필수' 설정.
   - **일정**: 설치 시점 지정 (새로 만들기, 사용자 로그온/로그오프 시, 최대한 빨리).
   - **사용자 경험**: 기본값 사용.
   - **배포 지점**: 기본값 사용.
5. 마법사 완료.
6. **모니터링** > **배포** 노드에서 진행 상태 모니터링.
```

--------------------------------

### LINQ to SQL Usage Steps

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/linq/typical-steps-for-using-linq-to-sql_source=recommendations

Provides general steps for using LINQ to SQL, including getting started, capabilities, and downloading sample databases and tools.

```APIDOC
LINQ to SQL General Steps:
  Getting Started: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/linq/getting-started
  What you can do with LINQ to SQL: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/linq/what-you-can-do-with-linq-to-sql
  Typical steps for using LINQ to SQL: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/linq/typical-steps-for-using-linq-to-sql
  Downloading sample databases and tools: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/sql/linq/downloading-sample-databases
```

--------------------------------

### LINQ to DataSet in .NET Framework

Source: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/how-to-create-a-linq-to-dataset-project-in-vs

Documentation for using Language Integrated Query (LINQ) with DataSets in the .NET Framework, including getting started, loading data, and project creation.

```APIDOC
LINQ to DataSet:
  Getting Started: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/getting-started-linq-to-dataset
  Overview: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/linq-to-dataset-overview
  Loading Data into a DataSet: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/loading-data-into-a-dataset
  Download Sample Databases: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/downloading-sample-databases-linq-to-dataset
  How to: Create a LINQ to DataSet Project in Visual Studio: https://learn.microsoft.com/ko-kr/dotnet/framework/data/adonet/how-to-create-a-linq-to-dataset-project-in-vs
```