c# - Access remote file contents as a stream using WinSCP .NET assembly

Question

I am trying to open file to read from SFTP using WinSCP .NET assembly as par to my exercise to archive file from SFTP to Azure blob.

To upload a blob to Azure, I am using

using (var fileStream = inputStream)
{
    blockBlob.UploadFromStream(fileStream);
    blobUri = blockBlob.Uri.ToString();
}

How to get the stream from the file on SFTP server?

I managed using SftpClient to get the stream using the following code and it works but unfortunately not able to achieve the same using WinSCP .NET assembly.

sftpClient.OpenRead(file.FullName)

Can anyone help me how to achieve the same using WinSCP .NET assembly?

Because I need to connect to SFTP using username, password and privatekey I am using WinSCP .NET assembly.

Thanks

Answer 1

The WinSCP .NET assembly supports providing the contents of a remote file using streams only in the current beta version (5.18), using the Session.GetFile method:

using (Stream stream = session.GetFile("/path/file.ext"))
{
    blockBlob.UploadFromStream(stream);
}

---

With the current stable version, all you can do, is to download the remote file to a local temporary location using the Session.GetFileToDirectory (or similar) and read the file from there:

// Download the remote file to the temporary location
var transfer = session.GetFileToDirectory("/path/file.ext", Path.GetTempPath());

try
{
    // Open the temporarily downloaded file for reading
    using (Stream stream = File.OpenRead(transfer.Destination))
    {
        // use the stream
        blockBlob.UploadFromStream(stream);
        blobUri = blockBlob.Uri.ToString();
    }
}
finally
{
    // Discard the temporarily downloaded file
    File.Delete(transfer.Destination);
}