Document Details
Tutorial Copy Data Dot Net
❌
This page contains Windows bias
About This Page
This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
Bias Analysis
Bias Types:
⚠️
powershell_heavy
⚠️
windows_first
⚠️
missing_linux_example
⚠️
windows_tools
Summary:
The documentation demonstrates a strong Windows bias by exclusively using Visual Studio (a Windows-centric IDE), .NET SDK, and NuGet Package Manager Console (PowerShell-based) for all code and setup instructions. There are no examples or guidance for Linux or cross-platform development environments (e.g., VS Code, CLI, or Python SDK). All tooling and workflow steps assume a Windows environment, omitting Linux equivalents for project creation, package management, and database access/validation.
Recommendations:
- Provide equivalent instructions for Linux users, such as using VS Code or JetBrains Rider for C# development, and include CLI-based project creation (dotnet CLI) instead of only Visual Studio.
- Show how to install required NuGet packages using the dotnet CLI (e.g., 'dotnet add package ...') rather than only the Package Manager Console.
- Mention and provide examples for using the Azure Data Factory Python SDK or REST API, which are cross-platform.
- Include instructions for connecting to Azure SQL Database using cross-platform tools like Azure Data Studio or sqlcmd, not just SQL Server Management Studio (SSMS) or Visual Studio.
- Add a note or section on how to run and debug the sample code on Linux or macOS, including any prerequisites or differences.
- Ensure all screenshots and UI references are either cross-platform or alternatives are provided for Linux/macOS users.
Create pull request
Scan History
| Date | Scan ID | Status | Bias Status |
|---|---|---|---|
| 2025-09-16 00:00 | #113 | completed | ✅ Clean |
| 2025-09-15 00:00 | #112 | completed | ✅ Clean |
| 2025-09-14 00:00 | #111 | completed | ✅ Clean |
| 2025-09-13 00:00 | #110 | completed | ✅ Clean |
| 2025-09-12 00:00 | #109 | completed | ✅ Clean |
| 2025-09-11 00:00 | #108 | completed | ✅ Clean |
| 2025-09-10 00:00 | #107 | completed | ✅ Clean |
| 2025-09-09 00:00 | #106 | completed | ✅ Clean |
| 2025-09-08 00:00 | #105 | completed | ✅ Clean |
| 2025-08-17 00:01 | #83 | in_progress | ✅ Clean |
| 2025-07-13 21:37 | #48 | completed | ✅ Clean |
| 2025-07-09 13:09 | #3 | cancelled | ✅ Clean |
| 2025-07-08 04:23 | #2 | cancelled | ❌ Biased |
Flagged Code Snippets
2. Allow Azure services to access SQL Database. Ensure that you allow access to Azure services in your server so that the Data Factory service can write data to SQL Database. To verify and turn on this setting, do the following steps:
1. Go to the [Azure portal](https://portal.azure.com) to manage your SQL server. Search for and select **SQL servers**.
2. Select your server.
3. Under the SQL server menu's **Security** heading, select **Firewalls and virtual networks**.
4. In the **Firewall and virtual networks** page, under **Allow Azure services and resources to access this server**, select **ON**.
## Create a Visual Studio project
Using Visual Studio, create a C# .NET console application.
1. Open Visual Studio.
2. In the **Start** window, select **Create a new project**.
3. In the **Create a new project** window, choose the C# version of **Console App (.NET Framework)** from the list of project types. Then select **Next**.
4. In the **Configure your new project** window, enter a **Project name** of *ADFv2Tutorial*. For **Location**, browse to and/or create the directory to save the project in. Then select **Create**. The new project appears in the Visual Studio IDE.
## Install NuGet packages
Next, install the required library packages using the NuGet package manager.
1. In the menu bar, choose **Tools** > **NuGet Package Manager** > **Package Manager Console**.
2. In the **Package Manager Console** pane, run the following commands to install packages. For information about the Azure Data Factory NuGet package, see [Microsoft.Azure.Management.DataFactory](https://www.nuget.org/packages/Microsoft.Azure.Management.DataFactory/).
## Run the code
Build the application by choosing **Build** > **Build Solution**. Then start the application by choosing **Debug** > **Start Debugging**, and verify the pipeline execution.
The console prints the progress of creating a data factory, linked service, datasets, pipeline, and pipeline run. It then checks the pipeline run status. Wait until you see the copy activity run details with the data read/written size. Then, using tools such as SQL Server Management Studio (SSMS) or Visual Studio, you can connect to your destination Azure SQL Database and check whether the destination table you specified contains the copied data.
### Sample output