LINQ query Option strict on disallows conversions from String to Boolean

Help
,
1

Hello,

I took a LINQ query from here to replace the value of the whole column without using the For Each.

I am getting an error that says Option strict on disallows conversions from String to Boolean which I understand comes from the Where clause, but I do not know LINQ enough to resolve it. Please can somebody help with the correct LINQ query to do this?

Capture1
Capture11235×555 65.1 KB

Thank you for your help.
byuli

1 Like
2

@byuli
the result of the lambda function within a Where method hast to be true or false (Boolean)
the LINQ is failing on that, as replace is returning a string and not a boolean

3

Hi @byuli,

You may try the same approach.

Thanks :slight_smile:

4

Thank you, so the LINQ expression is incorrect originally?

5

Yes, is incorrect. Also using LINQ within an assign updating selective 1 col will fail.

  • work with a for each row activity
    Or
  • construct the entire new corrected datatable with LINQ