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