Thursday, May 22, 2008

Tool to generate .net query or fetchXML in CRM

Following stunware tool is pretty useful that lets you graphically build a query that generates either fetchXml or c# / vb.net query which you can copy and paste in your code in CRM 4.0

http://www.stunnware.com/crm2/topic.aspx?id=Framework1

Similar tool for CRM 3.0 can be found too at - http://www.stunnware.com/crm2/topic.aspx?id=FindingData6

Often you may have faced cryptic errors from CRM web service like "0x80041103: The specified attribute does not exist on this entity. Platform" that burns quite few hours. Most of the time this is because of incorrect query statements or mispelled words or something very trivial to catch your eyes. Hence this is of great help. Though i still prefer hand coding myself as that is a great learning! :)

No comments: