Hi,
To retireve the values for all the attributes of an entity we can make use of ALLColumns ,
CrmService service=new CrmService();
service.Credentials = System.Net.CredentialCache.DefaultCredentials;
QueryExpression query = new QueryExpression();
query.EntityName = EntityName.new_entityname.ToString();
query.ColumnSet=new AllColumns();
BusinessEntityCollection entities= service.RetrieveMultiple(query);
for(int i=0;i<entities.BusinessEntities.Length;i++)
{
new_entityname nEntity=(new_entityname) entities.BusinessEntities[i];
Response.Write(“<b>”+nEntity.new_id+” -></b>”);
Response.Write(“<i>” + nEntity.createdby.name + ” –></i>”);
}
}
Or by using QueryByAttribute
It can be used when our query is very simple i.e. multiple equals conditions that are combined using AND.
But remember it doesn’t support OR
QueryByAttribute myQuery=new QueryByAttribute();
myQuery.ColumnSet=new AllColumns();
myQuery.EntityName=EntityName.opportunity.ToString();
// Find all the opportunities with topic name test1 and city as Redmond
myQuery.Attributes=new string[]{“name”,”address1_city”};
myQuery.Values=new string[]{“Test1″,”Redmond”};
BusinessEntityCollection retrieved=service.RetrieveMultiple(myQuery);
Bye
Share this:
