Hi,
I have this following fetch xml for retrieving the accounts from the subgrid of some other entity(N:N relationship exists between account and the other entity)
string query = @"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
<entity name='account'>
<attribute name='name' />
<attribute name='accountid' />
<order attribute='name' descending='false' />
<link-entity name='N:N relationship schema name' from='accountid' to='accountid' visible='false' intersect='true'>
<link-entity name='Second Entity' from='SecondEntityid' to='SecondEntityid' alias='ab'>
<filter type='and'>
<condition attribute='SecondEntityid' operator='eq' value='12345' />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>";
Now, I want to use LinQ insted of fetchXml. Help me out!
Thanks,
Madhan