DataSource

public static class DataSource
{
    private static readonly string _databaseFileName = @"\C1NWind.db";
    private static readonly List<KeyValuePair<int, string>> paths = new()
    {
        new KeyValuePair<int, string>(1, Environment.CurrentDirectory),
        new KeyValuePair<int, string>(2, Environment.GetFolderPath(Environment.SpecialFolder.Personal) + @"\ComponentOne Samples\Common")
    };

    public static string GetPathDb()
    {
        var existsDb = paths.Select(x => new
        {
            Priority = x.Key,
            Path = x.Value + _databaseFileName,
            Exists = File.Exists(x.Value + _databaseFileName)
        })
        .Where(x => x.Exists)
        .OrderBy(x => x.Priority)
        .FirstOrDefault()?.Path ?? "";

        return existsDb;
    }

    private static bool CheckDatabase()
    {
        var existsPathDb = GetPathDb();
        if (string.IsNullOrEmpty(existsPathDb))
        {
            var message = $"File {_databaseFileName} not found! {Environment.NewLine}" +
                $"{string.Join(Environment.NewLine, paths.Select(x => x.Value).ToArray())}";
            MessageBox.Show(message, "Error");

            return false;
        }

        return true;
    }

    private static IEnumerable<DataColumn> CreateColumns(SqliteDataReader reader, IEnumerable<string> imageColumns = null)
    {
        var columns = new List<DataColumn>();
        var dateColumnNames = new List<string>() { "datetime", "date" };

        if (reader.HasRows)
        {
            // Create base columns 
            var schemaTable = reader.GetSchemaTable();
            columns = (from s in schemaTable.Rows.Cast<DataRow>() select s)
                .Select(x => new
                {
                    // Name field
                    ColumnName = x["ColumnName"].ToString(),
                    // Database type
                    DataTypeName = x["DataTypeName"].ToString().ToLower(),
                    // System type
                    SystemType = Type.GetType(x["DataType"].ToString())
                })
                .Select(x => new DataColumn()
                {
                    ColumnName = x.ColumnName,
                    DataType =
                        // Check type as date
                        dateColumnNames.Any(y => y == x.DataTypeName) ? typeof(DateTime) :
                        imageColumns != null ?
                            // Check type as image
                            imageColumns.Any(y => y == x.ColumnName) ? typeof(Image) : x.SystemType
                        : x.SystemType
                }).ToList();
        }

        return columns;
    }

    private static Image Base64ToImage(string base64String)
    {
        // Convert base 64 string to byte[]
        byte[] imageBytes = Convert.FromBase64String(base64String);
        // Convert byte[] to Image
        using var ms = new MemoryStream(imageBytes, 0, imageBytes.Length);
        Image image = Image.FromStream(ms, true);
        return image;
    }

    public static DataTable GetRows(string queryString,
        string tableName = "Result", IEnumerable<string> imageColumns = null)
    {
        var table = new DataTable(tableName);
        var existsPathDb = GetPathDb();
        if (!CheckDatabase())
            return null;

        var connectionString = string.Format("Data Source={0}", existsPathDb);
        using (SqliteConnection connection = new(connectionString))
        {
            using SqliteCommand command = new(queryString, connection);
            // Open SQLite database
            connection.Open();
            var reader = command.ExecuteReader();
            var columns = CreateColumns(reader, imageColumns);
            table.Columns.AddRange(columns.ToArray());

            if (columns.Any())
            {
                while (reader.Read())
                {
                    // Fill table
                    var row = table.NewRow();
                    var arrayColumns = columns.ToArray();
                    Enumerable.Range(0, reader.FieldCount)
                        .ToList()
                        .ForEach(x =>
                        {
                            var currentColumns = arrayColumns[x];
                            bool IsImageColumn = imageColumns != null && (imageColumns.Any(y => y == currentColumns.ColumnName));

                            if (IsImageColumn)
                                row[x] = Base64ToImage(reader[x].ToString());
                            else
                                row[x] = reader[x];
                        });

                    table.Rows.Add(row);
                }

                return table;
            }
        }

        return null;
    }
}