FetchXML

During Custom Development in Dynamics CRM 4.0, we could interact with CRM Entities in two ways.

Method 1 (QueryExpression, QueryByAttribute)
Method 2 FetchXML

Method 1 is simple to use as We get Intellisense support in Visual Studio IDE (using CRMSdk) but one of the major limitation is the resultset is limited to only one Entity. So if you want resultset combining attributes of two entities, we cannot do that.

FetchXML comes to the rescue for the later part when the query becomes complex. Lot many times building FetchXML by hand is prone to errors, so if there any utility which can build fetchxml would be awesome and make the development effort more quicker.

I use the FetchXML Builder Utility from James Downey.. so If anybody need info about this.. you can get from here..

http://jamesdowney.net/blog/post/CRM-40-Version-of-FetchXML-Builder-Released-(Finally).aspx