Linq except function are case sensitive - how to ignore case sensitive

Help Studio
1

Hi Team,

I have 2 data table and except function returns case sensitive results also, how to ignore case sensitive. Please help

DT1

image

DT2

image

Using except function and copying it into dt3
dt3 = dt1.AsEnumerable.Except(dt2.AsEnumerable(), system.Data.DataRowComparer.Default).CopyToDataTable

dt3
image

2

Try to use StringComparer:

dt1.AsEnumerable.Except(dt2.AsEnumerable(), StringComparer.OrdinalIgnoreCase).ToList();

3

I guess I can’t use StringComparer straight in this context because dt.AsEnumarbale() is of DataRow so it can’t be inferred as String.

image
image1282×279 18 KB