LINQ: выберите значения из двух столбцов на основе значения одного из столбцов. ⇐ C#

[Гость]

I have a table like this:
Column A Column B Peter Apple Peter Orange Peter Melon John Apple John Potato John Melon Suzane Kiwi Suzane Cucumber Suzane Orange
I need to select values from Column A and values from Column B where Column B contains value Orange, so the resulting table should look like:
Column A Column B Peter Apple Peter Orange Peter Melon Suzane Kiwi Suzane Cucumber Suzane Orange
Is this possible preferably in LINQ or Entity Framework please?

I've tried to find similar question, but have not succeeded so far


Источник: https://stackoverflow.com/questions/781 ... lumn-value