Convert QueryExpression to FetchXML and FetchXML to QueryExpression in MSCRM

It might a very common requirement that sometimes you need to convert FetchXMl to QueryExpression and Vice-Versa. Today i am going to share the same with all of you.

Query Expression to Fetch XML :

QueryExpression query = new QueryExpression(); 

            query.EntityName = \”contact\”;

            query.ColumnSet = new ColumnSet(true);

            ConditionExpression cond = new ConditionExpression();

            cond.AttributeName = \”firstname\”;

            cond.Operator = ConditionOperator.Equal;

            cond.Values.Add(\”Varun Singh\”);

            // Create Request

            QueryExpressionToFetchXmlRequest Queryexp_to_Fetch_req = new QueryExpressionToFetchXmlRequest();

            Queryexp_to_Fetch_req.Query = query;

            //Get Response

            QueryExpressionToFetchXmlResponse Queryexp_to_Fetch_resp = (QueryExpressionToFetchXmlResponse)service.Execute(Queryexp_to_Fetch_req);

            //work with newly formed fetch string

            string myfetch = Queryexp_to_Fetch_resp.FetchXml;

Fetch XML to Query Expression :

FetchXmlToQueryExpressionRequest fetch_to_QueryExp_req = new FetchXmlToQueryExpressionRequest();

            fetch_to_QueryExp_req.FetchXml = myfetch;

            FetchXmlToQueryExpressionResponse fetch_to_QueryExp_resp = (FetchXmlToQueryExpressionResponse)service.Execute(fetch_to_QueryExp_req);

            QueryExpression myquery = fetch_to_QueryExp_resp.Query;

Hope it will help someone……..

Advertisement