public static async Task Execute(string search) { if (string.IsNullOrWhiteSpace(search)) { throw new ArgumentException("Value cannot be null or whitespace.", nameof(search)); } await using var connection = new Microsoft.Data.SqlClient.SqlConnection(Configuration.ConnectionString); await connection.OpenAsync(); foreach (var table in connection.ExecuteQuery("SELECT * FROM INFORMATION_SCHEMA.TABLES ORDER BY TABLE_NAME").ToList()) { var tableName = table["TABLE_NAME"]; //Console.WriteLine(tableName); foreach (var row in connection.ExecuteQuery($"SELECT * FROM [{tableName}]")) { foreach (var value in row.Values) { if (value == null) { continue; } var stringValue = value.ToString(); if (stringValue.Equals(search, StringComparison.OrdinalIgnoreCase)) { Console.WriteLine($"{tableName} " + row.First().Key + " #" + row.First().Value); } } } } }