C#- SQL Server on Ubuntu 検索結果をAzure Blob Storage に保存 (ChatGPT 利用) No.108

$dotnet new console -o TestApp2302
$cd TestApp2302
$code .

$ls
obj  Program.cs  TestApp2302.csproj

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>Exe</OutputType>
    <TargetFramework>net6.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="System.Data.SqlClient" Version="4.8.5"/>
    <PackageReference Include="Azure.Storage.Blobs" Version="12.14.1"/>
  </ItemGroup>


</Project>

dotnet restore

using System.IO;
using System.Data.SqlClient;
using Azure.Storage.Blobs;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
        // set path to local file etc
        String localpath = @"/home/xxx/TestApp2302/data.csv";
        String ConnectionString = "DefaultEndpointsProtocol=https;AccountName=xxxx;AccountKey=xxx;EndpointSuffix=core.windows.net";
        String containerName = "file";
        String blobName = "data.csv";

            try
            {
                // Build connection string
                SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
                builder.DataSource = "localhost";
                builder.UserID = "sa";
                builder.Password = "password";
                builder.InitialCatalog = "sampledb1";

                // Connect to SQL
                Console.Write("Connecting to SQL Server ... ");
                using (SqlConnection connection = new SqlConnection(builder.ConnectionString))
                {
                    connection.Open();
                    Console.WriteLine("Done.");
                    // execute select query
                    String sql = "SELECT id, cdatetime, note FROM sampletb";

                    using (SqlCommand command = new SqlCommand(sql, connection))
                    {
                        using (SqlDataReader reader = command.ExecuteReader())
                        {
                            // save data to csv file
                            using (System.IO.StreamWriter file = new System.IO.StreamWriter(localpath))
                            {
                                while (reader.Read())
                                {
                                    file.WriteLine("{0},{1},{2}", reader.GetInt32(0), reader.GetDateTime(1), reader.GetString(2));
                                }
                            }
                        }
                    }
                }
            }
            catch (SqlException e)
            {
                Console.WriteLine(e.ToString());
            }
            
            // Create a container and a blob client
            BlobServiceClient blobServiceClient = new BlobServiceClient(ConnectionString);
            BlobContainerClient container = blobServiceClient.GetBlobContainerClient(containerName);
            BlobClient blob = container.GetBlobClient(blobName);

            // Upload the file to the blob
            using (FileStream uploadFileStream = File.OpenRead(localpath))
            {
                blob.Upload(uploadFileStream, true);
                uploadFileStream.Close();
            }

            Console.WriteLine("\nUploaded to Blob storage as blob:\n\t {0}\n", blob.Uri);           
            Console.WriteLine("Blob uploaded");
            
        }
    }
}

$ dotnet run
Connecting to SQL Server ... Done.

Uploaded to Blob storage as blob:
	 https://xxx.blob.core.windows.net/file/data.csv

Blob uploaded

cat data.csv 

3366109,12/9/2022 1:59:12 PM,int
3366109,12/9/2022 1:59:12 PM,mcranentiv
6732218,12/9/2022 1:59:12 PM,orlsojlvuu
10098327,12/9/2022 1:59:12 PM,uaclnlkehv
13464436,12/9/2022 1:59:12 PM,xngcehsmtc
16830545,12/9/2022 1:59:12 PM,llvzgooqaa
20196654,12/9/2022 1:59:12 PM,atmordnpfz
23562763,12/9/2022 1:59:12 PM,qpzlferdra
26928872,12/9/2022 1:59:12 PM,lnbjlmclxx
30294981,12/9/2022 1:59:12 PM,xfspqvetbf
0,12/9/2022 1:59:12 PM,Description
852,1/7/2023 4:07:53 PM,Description