Problem with conversion of linq query to sql

[test]

Hi,

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 :

(from p in this.DbContext.PriceAgreements

where ((p.ItemRelationType == 0 && p.ItemRelationCode == ItemCode) || (p.ItemRelationType == 2 && p.ItemRelationCode == ""))

select p).ToList();

Here's the resulting sql query in trace file :

SELECT ....
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.

[Thomas]

Operator precedence allows to formulate the query without brackets. This is what's happening here.
Please see here for a list of those operator evaluation rules. As * has precedence over +, so does AND over OR.

Kind regards,
Thomas
the Telerik team