Hi Jerimias,
See : http://www.crmcodex.com/2011/12/tip-getting-around-a-contains-issue-in-linq-for-mscrm2011/
This uses the PredicateBuilder and AsExpandable to basically construct a dynamic LINQ query that is the equivalent of:
.Where(c=>comparison1 || comparison2 || ...)
You will need to download and reference LinqKit: http://www.albahari.com/nutshell/linqkit.aspx
If you want to test this out using LinqPad (http://www.linqpad.net/), first add a reference to LinqKit (press F4 in LinqPad), and add the following c# statements:
List<string> lastNames = new List<string>() {
"test 45",
"test 46",
"test 48"};
var predicate = PredicateBuilder.False<Contact>();
foreach (string lastName in lastNames)
{
string lastNameValue = lastName;
predicate = predicate.Or(c => c.LastName == lastNameValue);
}
var contacts = (
from c in ContactSet.AsExpandable().Where (predicate )
select new {Id = c.Id,LastName=c.LastName});
contacts.Dump();
Execute and look at the Query Expression created, it uses:
<Filters>
<FilterExpression>
<Conditions>
<ConditionExpression>
<AttributeName>lastname</AttributeName>
<Operator>Equal</Operator>
<Values xmlns:d7p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d7p1:anyType xmlns:d8p1="http://www.w3.org/2001/XMLSchema" i:type="d8p1:string">test 48</d7p1:anyType>
</Values>
</ConditionExpression>
</Conditions>
<FilterOperator>Or</FilterOperator>
<Filters>
<FilterExpression>
<Conditions>
<ConditionExpression>
<AttributeName>lastname</AttributeName>
<Operator>Equal</Operator>
<Values xmlns:d9p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d9p1:anyType xmlns:d10p1="http://www.w3.org/2001/XMLSchema" i:type="d10p1:string">test 45</d9p1:anyType>
</Values>
</ConditionExpression>
<ConditionExpression>
<AttributeName>lastname</AttributeName>
<Operator>Equal</Operator>
<Values xmlns:d9p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d9p1:anyType xmlns:d10p1="http://www.w3.org/2001/XMLSchema" i:type="d10p1:string">test 46</d9p1:anyType>
</Values>
</ConditionExpression>
</Conditions>
<FilterOperator>Or</FilterOperator>
<Filters />
</FilterExpression>
</Filters>
</FilterExpression>
</Filters>
It's interesting that the CRM Linq provided uses a single Filter Expression for the first comparison, then groups the rest as multiple filters in another filter expression.
Scott
www.develop1.net
