compare records in two filesets

Question

Hi,

There are two filesets,named A and B.The records in A are:

1

2

3

The records in B are:

2

3

4

So,how can i get the record "4" from fileset B.Because B`s records 2 and 3 are contained in A .Namely,the records which are contained in B and do not contained in A are what i want.

How can i achieve this?

thanks

Answer 1

Use the Join() operator to do this.

http://msdn.microsoft.com/en-us/vcsharp/aa336746

http://msdn.microsoft.com/en-us/library/bb534650.aspx

There's an example that shows a simple join in the samples with the beta.

Ade

---

Ade

Answer 2

You can use the built-in operator IQueryable.Except().

The definition of Except (http://msdn.microsoft.com/en-us/library/bb348938.aspx) requires that you say B.Except(A) in order to achieve what you want.

 

-Mike.