Hello maze_dk,
Here is one way you could do it through FetchXML:
<fetch mapping='logical'>
<entity name='account'>
<filter type='and'/>
<filter type='and'>
<condition attribute='accountid' operator='eq' value='1B12B39E-E38C-DA11-829C-0003FF020F6E'/>
</filter>
<link-entity name='contact' from='accountid' to='accountid' link-type='inner'>
<attribute name='firstname'/>
<attribute name='lastname'/>
</link-entity>
</entity>
</fetch>
Here is the code in C# (generated from the same FetchXML above):
QueryExpression query = new QueryExpression();
query.EntityName="account";
ColumnSet columns = new ColumnSet();
columns.Attributes = new string[] { };
query.ColumnSet = columns;
query.Criteria = new FilterExpression();
query.Criteria.FilterOperator = LogicalOperator.And;
query.Criteria = new FilterExpression();
query.Criteria.FilterOperator = LogicalOperator.And;
ConditionExpression condition1 = new ConditionExpression();
condition1.AttributeName = "accountid";
condition1.Operator = ConditionOperator.Equal;
condition1.Values = new object[] { "1B12B39E-E38C-DA11-829C-0003FF020F6E" };
query.Criteria.Conditions = new ConditionExpression[] { condition1 };
LinkEntity linkEntity1 = new LinkEntity();
linkEntity1.JoinOperator = JoinOperator.Inner;
linkEntity1.LinkFromEntityName = "account";
linkEntity1.LinkFromAttributeName = "accountid";
linkEntity1.LinkToEntityName = "contact";
linkEntity1.LinkToAttributeName = "accountid";
query.LinkEntities = new LinkEntity[] { linkEntity1 };
The tool I used for this can be downloaded from: http://jamesdowney.net/fetchxml/FetchXMLBuilder4.zip
Good Luck!
Oliver
oliver barrera
