Introduction
On 07/11/2023, the .NET 8 Preview 6 was launched with a new overload for the ZipFile, CreateFromDirectory method.
Now it's possible to use a stream to compress files from a directory without caching them in a temporary file. Now we can manage the compression result directly in the memory.
The basic usage example.
ZipFile.CreateFromDirectory(
sourceDirectoryName: "/path/filesToCompress",
destination: stream,
compressionLevel: CompressionLevel.Fastest,
includeBaseDirectory: true,
entryNameEncoding: Encoding.UTF8);
The stream variable we can create is like this.
Stream stream = new MemoryStream();
And transform in a byte array.
using var memoryStream = new MemoryStream();
stream.Position = 0;
stream.CopyTo(memoryStream);
var fileBytes = memoryStream.ToArray();
Here's a working example of reading and saving a directory on a Table in Microsoft SqlServer. Add this code to a console app in Program.cs file using a .NET 8 Preview 6 SDK (minimum).
using System.Data.SqlClient;
using System.IO.Compression;
using System.Text;
string connectionString = "Data Source=localhost;Initial Catalog=MyCatalog;Integrated Security=SSPI;";
Stream stream = new MemoryStream();
Console.WriteLine("Compressing...");
ZipFile.CreateFromDirectory(
sourceDirectoryName: "C:\\MyLocalFiles",
destination: stream,
compressionLevel: CompressionLevel.Fastest,
includeBaseDirectory: true,
entryNameEncoding: Encoding.UTF8);
using var connection = new SqlConnection(connectionString);
Console.WriteLine("Openning DB Connection...");
connection.Open();
string sqlQuery = "INSERT INTO MyTable (MyFieldStreamData) VALUES (@StreamData)";
using var command = new SqlCommand(sqlQuery, connection);
var parameter = new SqlParameter("@StreamData", System.Data.SqlDbType.VarBinary);
using var memoryStream = new MemoryStream();
stream.Position = 0;
stream.CopyTo(memoryStream);
var fileBytes = memoryStream.ToArray();
parameter.Value = fileBytes;
command.Parameters.Add(parameter);
Console.WriteLine("Writing on DB...");
command.ExecuteNonQuery();
Console.WriteLine("Press any key...");
Console.ReadKey();
To try this example, you need to create a table using this code:
CREATE TABLE [dbo].[MyTable](
[MyFieldStreamData] [varbinary](max) NOT NULL
It's supported to use other Stream classes from C#.
