Select all column in QueryExpression CRM 2011

c# dynamics-crm-2011 dynamics-crm
Romeo picture Romeo · Apr 22, 2014 · Viewed 14.3k times · Source

I have this QueryExpression in my code.

 QueryExpression query = new QueryExpression() { };

 query.EntityName = "country";
 query.ColumnSet = new ColumnSet("name", "2digitiso", "3digitiso");

 EntityCollection retrieved = _service.RetrieveMultiple(query);

My question is, Is there a way to select all the columns in the "country" without providing any ColumnSet? pretty much I want something like the SELECT * from the SQL Query.

Answer

Kevin Ross picture Kevin Ross · Apr 22, 2014

Yes, if you change your third line to look like this

query.ColumnSet = new ColumnSet(true);

then it will select all columns

Related questions

Error registering plugins and/or workflows. Plug-in assembly does not contain the required types or assembly content cannot be updated

I implemented one custom workflow in in Visual Studio 2010 using CRM 2011 Developer Toolkit. It was working fine with system generated namespace. But, when I changed the namespace of my project, its throwing an error "Error registering plugins and/or workflows. …

Read More
The namespace '<global namespace>' already contains a definition for 'Workflow'

I'm working on a Custom workflow activity. I've created my own helper.cs (Early Bound Entity Classes) with the Code Generation Tool (CrmSvcUtil.exe) When I try to compile the code, it returns the following error: The namespace '' already …

Read More
Can't access Microsoft.Xrm namespace

I've downloaded CRM Dynamics SDK and keep it in a local directory. In my code, I'm using EntityCollection (amongst other classes related to Xrm namespace), which means that I need to add using Microsoft.Xrm.Sdk;. The problem is that …

Read More