LINQ???

[Brian]

I don't have my book with me today...
but I thought I saw a sample in the book that .. I have one dataset.. two
tables.... columns are identicaly.. with the exception of a few column
names, but column types are the same
with the dataset I should be about to a querry againt it such as something
like
select * from table_a x
where not exists
(select * from table_b where x.[pk]=[pk])


I would put the results into another table in that dataset.. to do other
things with.. such as insert data from table a into b to bring table b
update.. or color the rows in table a that have been modified or added ..
any help would be great.
Thanks.. Brian

 

[David Glienna]

Use two LINQ statements. First, get Table_A's data, then loop thru each
record for a match. You can sort the first table also. Then, something
like this:

Public Sub LinqToSqlExists01()
Dim q = From c In db.Customers _
Where Not c.Orders.Any()

ObjectDumper.Write(q)
End Sub

http://msdn.microsoft.com/en-us/vbasic/bb688088.aspx

- David