Extract SQL Image Hex string to File

Program.cs

const string BaseData = "0xFFD8FFE0..."
await ConvertToImage("data", BaseData);

static async Task ConvertToImage(string file, string hex)
{
    string format = GetFormat(hex);
    byte[] data = Convert.FromHexString(hex.Remove(0, 2));
    
    await File.WriteAllBytesAsync($"{file}{format}", data);
}

static string GetFormat(string hex) => new string(hex.Take(6).ToArray()) switch
{
    "0xFFD8" => ".jpg",
    "0x8950" => ".png",
    _ => throw new Exception("The provided data is not an image")
};