Query :: using the same variable in query twice results in sql with two different parameters, with the same values

[maumar]

linq query:

int i = 10;
            AssertQuery<Customer>(
                cs => cs.Where(c => i + 20 + c.CustomerID + i + 42 == c.CompanyName).Select(c => c.CustomerID));

SQL:

@__i_0: 10
@__i_1: 10

SELECT [c].[CustomerID]
FROM [Customers] AS [c]
WHERE (((CAST(@__i_0 + 20 AS nvarchar(max)) + [c].[CustomerID]) + CAST(@__i_1 AS nvarchar(max))) + CAST(42 AS nvarchar(max))) = [c].[CompanyName]

[smitpatel]

Already fixed in 3.0 release. Test is bit different. In above case we condense i + 20 into one parameter so it generates 2 parameters with different values.