C#SqlCommand - 不能使用参数作为列名,如何解决？

string columnName = "your_column_name";
string sql = $"SELECT * FROM your_table WHERE {columnName} = @value";
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@value", yourValue);

string columnName = "your_column_name";
string sql = $"EXEC sp_executesql N'SELECT * FROM your_table WHERE {columnName} = @value', N'@value your_column_type', @value = @value";
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("@value", yourValue);

var data = from row in yourDataContext.your_table
           where row.GetType().GetProperty(columnName).GetValue(row, null).Equals(yourValue)
           select row;