Fetch XML in C# using Xrm.SDK

(0) Share

Report

Posted on by Community Member

Hi,

In CRM 4.0 and CRM 11 there is function Fetch() to get data from the XML, we can do that using Crm.SDK but in Xrm.SDK there is no function available name Fetch().

I have used Odata with JavaScript, but i don't know how to use it with C#.

Please Help...!!!

Thanks

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Aileen Gusni 44,524 on at

Like (0)

Report

Hi Chirag,

You can use

RetrieveMultiple(new FetchExpression(fetchxml)) function.

But, different from .Fetch() in CRM 4.0, both input and output are string XML.

in CRM 2011 and CRM 2013 we can use XML as input using that FetchExpression(fetchxml), but it will return EntityCollection()

See this:

msdn.microsoft.com/.../gg328117.aspx

msdn.microsoft.com/.../gg328332.aspx

Hope this helps!

Thanks.

Was this reply helpful? Yes No
Waqar Sohail on at

Like (0)

Report
Hi You can also use Query Expression to retrieve Data in C#.

QueryExpression query = new QueryExpression("EntityLogicalName"); query.ColumnSet = new ColumnSet("column1", "coumn2"); // Or retrieve All Columns //query.ColumnSet = new ColumnSet(true); query.Criteria.Conditions.Add(new ConditionExpression("status", ConditionOperator.Equal, 1)); var result = service.RetrieveMultiple(query); foreach (var entity in result.Entities) { // Get the Columns from the Entity Obj Like this. Depands on type of the Column. string entityColumn1 = entity.Contains("column1") ? entity["column1"].ToString() : string.Empty; }

Regards

Was this reply helpful? Yes No
suresh maurya 630 on at

Like (0)

Report

For testing of FetchXML, you can test here online http://msxrmtools.com

Was this reply helpful? Yes No