public static string FilesFewZip(string direct, List<int> RowId)
        {
            //Путь к загрузке файла из blob
            string TargetPath = System.IO.Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "CPW");
            string DestFilePath = System.IO.Path.Combine(TargetPath, "Архив_" + direct + ".zip");
            if (!System.IO.Directory.Exists(TargetPath))
            {
                System.IO.Directory.CreateDirectory(TargetPath);
            }
            FileStream fileStream = File.Create(DestFilePath);
            //////////////////////////////
            try
            {
                int PictureCol = 0;  // position of Picture column in DataReader
                int BUFFER_LENGTH = 32768; // chunk size

                using (var connection = new SqlConnection(Connect.str_conn("CPW_files")))
                {

                    // Make sure Photo is non-NULL and return TEXTPTR to it.
                    using (ZipArchive archive = new ZipArchive(fileStream, ZipArchiveMode.Create, true))
                    {

                        foreach (var id in RowId)
                        {

                            SqlCommand cmdGetPointer =
                                new SqlCommand(
                                    "SELECT @Pointer=TEXTPTR(Data), @Length=DataLength(Data), @fileName=[FileName]+'.'+[Extention] FROM Files WHERE RowID=" +
                                    id, connection);
                            SqlParameter PointerOutParam = cmdGetPointer.Parameters.Add("@Pointer", SqlDbType.VarBinary, 100);
                            PointerOutParam.Direction = ParameterDirection.Output;
                            SqlParameter LengthOutParam = cmdGetPointer.Parameters.Add("@Length", SqlDbType.Int);
                            LengthOutParam.Direction = ParameterDirection.Output;
                            SqlParameter fileNameOutParam = cmdGetPointer.Parameters.Add("@fileName", SqlDbType.VarChar, 500);
                            fileNameOutParam.Direction = ParameterDirection.Output;
                            connection.Open();
                            cmdGetPointer.ExecuteNonQuery();

                            SqlCommand cmdReadBinary = new SqlCommand("READTEXT Files.Data @Pointer @Offset @Size HOLDLOCK", connection);
                            SqlParameter PointerParam = cmdReadBinary.Parameters.Add("@Pointer", SqlDbType.Binary, 16);
                            SqlParameter OffsetParam = cmdReadBinary.Parameters.Add("@Offset", SqlDbType.Int);
                            SqlParameter SizeParam = cmdReadBinary.Parameters.Add("@Size", SqlDbType.Int);
                            SqlDataReader dr;
                            //System.IO.FileStream fs = new System.IO.FileStream(DestFilePath, System.IO.FileMode.Create,
                            //    System.IO.FileAccess.Write);
                            int Offset = 0;
                            OffsetParam.Value = Offset;
                            Byte[] Buffer = new Byte[BUFFER_LENGTH];


                            // Read buffer full of data and write to the file stream.


                            if ((Offset + BUFFER_LENGTH) >= System.Convert.ToInt32(LengthOutParam.Value))
                                SizeParam.Value = System.Convert.ToInt32(LengthOutParam.Value) - Offset;
                            else SizeParam.Value = BUFFER_LENGTH;

                            PointerParam.Value = PointerOutParam.Value;

                            dr = cmdReadBinary.ExecuteReader(CommandBehavior.SingleResult);
                            
                            while (dr.Read())
                            {
                                //var record = dr.GetString(0);
                                dr.GetBytes(PictureCol, 0, Buffer, 0, System.Convert.ToInt32(SizeParam.Value));
                                //Archive entry is a file inside archive.
                                ZipArchiveEntry entry = archive.CreateEntry((string)fileNameOutParam.Value, CompressionLevel.Optimal);

                                //Get stream to write the archive item body.
                                using (Stream entryStream = entry.Open())
                                {
                                    //All you need here is to write data into archive item stream.
                                    byte[] recordData = Buffer;//Encoding.Unicode.GetBytes(Buffer);
                                    MemoryStream recordStream = new MemoryStream(recordData);
                                    recordStream.CopyTo(entryStream);

                                    //Flush the archive item to avoid data loss on dispose.
                                    entryStream.Flush();
                                }
                            }
                            dr.Close();
                            connection.Close();
                        }
                    }


                }
            }
            catch (SqlException ex)
            {
                MessageBox.Show(ex.Message);
            }

            return DestFilePath;
        }

fc /b before.xlsx after.xlsx