GithubDBDProvider.cs

using DBCD.Providers;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net.Http;
using System.Text;
 
namespace DBCD.Tests
{
    class GithubDBDProvider : IDBDProvider
    {
        private readonly HttpClient client;
        private readonly Dictionary<string, string> lookup;
        private const string branch = "master";
 
        public GithubDBDProvider()
        {
            client = new HttpClient();
            client.DefaultRequestHeaders.Add("User-Agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/74.0.3729.169 Safari/537.36");
            string data = client.GetStringAsync("https://api.github.com/repos/wowdev/WoWDBDefs/contents/definitions?ref=" + branch).Result;
                
            var definitions = JsonConvert.DeserializeObject<ContentObject[]>(data);
            lookup = definitions.ToDictionary(x => Path.GetFileNameWithoutExtension(x.name), x => x.download_url, StringComparer.OrdinalIgnoreCase);
        }
        
        public Stream StreamForTableName(string tableName, string build = null)
        {
            var bytes = client.GetByteArrayAsync(lookup[tableName]).Result; 
            return new MemoryStream(bytes);
        }
 
        class ContentObject
        {
            public string name { get; set; }
            public string path { get; set; }
            public string sha { get; set; }
            public int size { get; set; }
            public string url { get; set; }
            public string html_url { get; set; }
            public string git_url { get; set; }
            public string download_url { get; set; }
            public string type { get; set; }
        }
    }
}