LINQ - syntex for "where and" in select - Asked By D N C on 14-Sep-11 05:31 AM

Hello,

Is this syntax right?
From p in x.y where ( p.col1 = "something" and p.col2= "something") select p ?????
iam using such a query in WPF-Vb.net application and its not giving the proper result.

Kindly help ASAP

Thank You :)

The operator that you are specifyig is wrong

use '=='

change the query like this




Cheers

That too was not working. giving an error. in Vb.net using "==" is not possible i think.
any other suggestions????

in what way is it not working?

what is it that you are getting?

actuallly it was showing no data earlier.
when i used ==, it threw an error like 'something expected'

but then i did like this:
dim str1 as string = "Something1"
dim str1 as string = "Something2"

and executed the same query as "from p in x.y where (p.col1=str1 and p.col2=str2) select p"

now its giving the expected result. :)

Thanks all for your time and interest...