I've a problem with a linq query that it's not well converted in sql query. The problem concern parentheses that are not correctly translated in my SQL query.
Here's my linq query :
where ((p.ItemRelationType == 0 && p.ItemRelationCode == ItemCode) || (p.ItemRelationType == 2 && p.ItemRelationCode ==
Here's the resulting sql query in trace file :
FROM [PriceAgreement] a WHERE (a.[ItemRelationType] = 0 AND a.[ItemRelationCode] = @p0 OR a.[ItemRelationType] = 2 AND a.[ItemRelationCode] =
) ORDER BY COL1
As you can see the parentheses are not well translated.
I use 2012.1.301 version of Open Access.
Thanks for your help.