I'm trying to do a LINQ Query against a typed datatable that will return me duplicated data.

With out going into too much detail, here's the basic setup:

strCode1 - string type
intCode1 - int32 type
intAdjustor - int32

There are more fields but these are the ones that are important.

I'm going to do my best to describe this, as it's kind of confusing.

In theory intCode1 is a key for strCode1 (hence the names). So each time intCode1 is duplicated, the same strCode1 should appear.
Example:
Code:
strCode1   intCode1   intAdjustor
12345       100          0
12345       100          0
12345       100          0
12345       100          0
54321       254          0
54321       254          0
54321       254          0
At the same time, there can be adjustments on the data... like so
Code:
strCode1   intCode1   intAdjustor
12345       100          0
12345       100          0
12345       100          0
12345       100          1
12345       100          2
12345       100          3
54321       254          0
54321       254          0
54321       254          5
But occasionally we will get the same strCode1, but for a DIFFERENT intCode1.
Code:
strCode1   intCode1   intAdjustor
12345       100          0
12345       100          0
12345       100          0
12345       100          1
12345       100          2
12345       100          3
12345       500          0
54321       254          0
54321       254          0
54321       254          5
54321       750          0
This causes a problem. The source of the data is an external system. Fortunately the point at which this causes a problem, is as it's coming in from this other system. What I'm trying to do is write a LINQ query, that will tell me when this situation occurs, so that we can warn the user, and then can then go to that external system, correct the data and perform the action again (it is for a conversion process that pulls out of one system and sends it into another.)

Ultimately I'd like to get a List(Of T) - where T is my typed data row.

In SQL, I would simply use a sub query, to get a distinct list of strCode1 and intCode1, then do a count, grouped by strCode1 where I get more than one row.

I'm not sure how to translate that into LINQ, AND get the original types data rows returned in a list.

-tg