views:

14

answers:

0

Dear All,

I want to get the unmatched records from DataTable1 by comparing DataTable2

eg :

Table 1

CallId   Destination     Call type

1           15515643       MOSE

2           16464996       MOSE

3           46169789       MOSTT

4           48892269       MOSTT


Table 2

CallId   Destination     Call type

1           15515643       Local

4           48892269       STD


I want to match the above two table by using column "CallId" and I want the result as Below

(Unmatched records of Table 1)

CallId   Destination     Call type

2           16464996       MOSE

3           46169789       MOSTT

How can I achive this by using LINQ ?????????

Please Help......