Compare Two Linq Queries

Asked Jun 10 '16 at 09:56

Active Jun 10 '16 at 09:56

Viewed 225 times

I have the following two queries that take information from the same table I need to compare the two tables and find all the information that's value is different. Is there any way to do this without having to make a loop?

Dim housepress = (From press In db.PressInfo
                          Where press.PressName = pressname And press.CustomerID = "House"
                          Select press).ToList()

        Dim curpress = (From press In db.PressInfo
                        Where press.PressName = pressname And press.CustomerID = Customername
                        Select press)

I tried using curpress.Except but I get an error that "Local sequence cannot be used in Linq to SQL

asked Jun 10 '16 at 09:56

Dman

check this for comparision http://stackoverflow.com/questions/10984453/compare-two-datatables-for-differences-in-c – Abdul Jun 10 '16 at 11:03
Why is the ToList there? – Ferdinand Swaters Jun 13 '16 at 09:28
@Abdul thank you, I didn't see this question – Dman Jun 14 '16 at 06:24
Possible duplicate of [Compare two Lists for differences](http://stackoverflow.com/questions/675699/compare-two-lists-for-differences) – Dman Jun 14 '16 at 11:08

Compare Two Linq Queries

0 Answers0