Bug #75710 LINQ SQL syntax exception calliing ,Any method on array with more than 2 element
Submitted: 31 Jan 2015 16:12 Modified: 3 Feb 2015 5:36
Reporter: Luca Piccirillo Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.9.5 OS:Windows (EntityFramweork 6.0.0)
Assigned to: CPU Architecture:Any
Tags: ANY, array, linq, SQL, syntax

[31 Jan 2015 16:12] Luca Piccirillo 
Description:
Executing the code below will result in LINQ exception when splits has more then two elements (ie. input contains more then two words), otherwise works as expected.

var context = new GlobalDBContext();
string[] splits = input.Split();
            var SearchQuery =
                    from tuple in context.tests
                    where splits.Any(split => tuple.Name.Contains(split))
                    select tuple;

How to repeat:
Run the above code with input = "a string with more than two words"

Suggested fix:
Spend more money into Connector/NET development
[31 Jan 2015 16:15] Luca Piccirillo 
Edit: synopsis adjusted
[3 Feb 2015 5:36] Chiranjeevi Battula 
Hello Luca Piccirillo,

Thank you for the bug report.
This is duplicate of Bug #74918.

Thanks,
Chiranjeevi.