Thursday, 10 July 2014

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........



















1 comment:

  1. Special thanks to (hackingsetting50@gmail.com) for exposing my cheating husband. Right with me i got a lot of evidences and proofs that shows that my husband is a fuck boy and as well a cheater ranging from his text messages, call logs, whats-app messages, deleted messages and many more, All thanks to

    (hackingsetting50@gmail.com), if not for him i will never know what has been going on for a long time.

    Contact him now and thank me later.

    ReplyDelete

Blogger Widgets