public static IList<string> GetColumnsForTable(this IDatabase db, string tableName)
{
var columns = new List<string>();
var rows =
db.Query(@"SELECT COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = @0", tableName)
.ToList();
if (rows.Any())
{
columns.AddRange(rows.Select(row => row[0]).Select(columnName => columnName).Cast<string>());
}
return columns;
}