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
For testing of FetchXML, you can test here online http://msxrmtools.com
Hi You can also use Query Expression to retrieve Data in C#.
Share
Report
All responses (
Answers (
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
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.
#1
André Arnaud de Cal...
291,820
Super User 2024 Season 2
#2
Martin Dráb
230,514
Most Valuable Professional
#3
nmaenpaa
101,156
