如何将FTP服务器上的ZIP文件中的数据导入到C#中的数据库

using System;
using System.IO;
using System.Net;

public class FtpHelper
{
    public static void DownloadFile(string ftpUrl, string username, string password, string localPath)
    {
        FtpWebRequest request = (FtpWebRequest)WebRequest.Create(ftpUrl);
        request.Method = WebRequestMethods.Ftp.DownloadFile;
        request.Credentials = new NetworkCredential(username, password);

        using (FtpWebResponse response = (FtpWebResponse)request.GetResponse())
        using (Stream responseStream = response.GetResponseStream())
        using (FileStream fileStream = new FileStream(localPath, FileMode.Create))
        {
            responseStream.CopyTo(fileStream);
        }
    }
}

using System.IO;
using System.IO.Compression;

public class ZipHelper
{
    public static void ExtractZipFile(string zipFilePath, string extractPath)
    {
        ZipArchive archive = ZipFile.OpenRead(zipFilePath);
        foreach (ZipArchiveEntry entry in archive.Entries)
        {
            string entryPath = Path.Combine(extractPath, entry.FullName);
            if (entry.Name != "")
            {
                if (entry.isDirectory)
                {
                    Directory.CreateDirectory(entryPath);
                }
                else
                {
                    entry.Open().CopyTo(new FileStream(entryPath, FileMode.Create));
                }
            }
        }
    }
}

using System;
using System.Data;
using System.Data.SqlClient;

public class DatabaseHelper
{
    public static void ImportCsvToDatabase(string csvFilePath, string connectionString, string tableName)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
            {
                bulkCopy.DestinationTableName = tableName;

                using (StreamReader reader = new StreamReader(csvFilePath))
                {
                    string header = reader.ReadLine();
                    string[] columns = header.Split(',');

                    DataTable table = new DataTable();
                    foreach (string column in columns)
                    {
                        table.Columns.Add(column);
                    }

                    string line;
                    while ((line = reader.ReadLine()) != null)
                    {
                        string[] values = line.Split(',');
                        DataRow row = table.NewRow();
                        for (int i = 0; i < columns.Length; i++)
                        {
                            row[columns[i]] = values[i];
                        }
                        table.Rows.Add(row);
                    }

                    bulkCopy.WriteToServer(table);
                }
            }
        }
    }
}