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

namespace AttachmentExporter
{
class Program
{
static void Main(string[] args) { // Adjust this connection string to your SQL Server string connectionString = "Server=YOUR_SERVER;Database=paygateInspector;Integrated Security=true;"; string outputFolder = @"C:\kvkk"; if (!Directory.Exists(outputFolder)) { Directory.CreateDirectory(outputFolder); } using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); string sql = "SELECT ID, RelatedID, FileName, FileContent FROM dbo.attachment"; using (SqlCommand cmd = new SqlCommand(sql, conn)) using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { string fileName = reader["FileName"].ToString();

// Some filenames may have invalid characters -> sanitize
foreach (char c in Path.GetInvalidFileNameChars())
{
fileName = fileName.Replace(c, '_');
}

string filePath = Path.Combine(outputFolder, fileName);

byte[] fileContent = reader["FileContent"] as byte[]; if (fileContent != null && fileContent.Length > 0) { try { File.WriteAllBytes(filePath, fileContent); Console.WriteLine($"Exported: {filePath}"); } catch (Exception ex) { Console.WriteLine($"Failed to export {filePath}: {ex.Message}"); } } else { Console.WriteLine($"Skipped ID={reader["ID"]} (empty content)");
}
}
}
}

Console.WriteLine("Export completed.");
}
}
}[/]; if (fileContent !][/] fileContent ][/] args) { // Adjust this connection string to your SQL Server string connectionString ]