Compare data between two columns and update the result in another column on the same table using linq.

[Arivazhagan K]

hi,

I have a table like below

Col1 Col1 ColRes ... ColN

1 1

2 3

2 2

And I want to update the ColRes Column based on the COL1 and Col2 value

Col1 Col1 ColRes ... ColN

1 1 True

2 3 False

2 2 True

I want to achieve this by linq not other method.

Please help

Continue reading...