I have two DataTables. I applied the Except operator as follows,
and got either unfiltered or undesired results.

```
resultDataTable = dtA.AsEnumerable().Except(dtB.AsEnumerable()).CopyToDataTable();

```

Could anyone please kindly explain to me why **Except(dtB.AsEnumerable())** is not the way to put it?

Note:
Both DataTables are plain simple with just one column.

* **dtA** contains a dozen rows of strings.
* **dtB** contains thousands of rows of strings.

I also tried the same syntax with another use case the set operator, Intersect. This does not work either.

resultDataTable2 =dtA.AsEnumerable().**Intersect(dtB.AsEnumerable())**.CopyToDataTable();