CODEWITHSUNDEEP
c#dynamics-crm-2011dynamics-crm
Romeo
Romeo

Reputation: 1831

Select all column in QueryExpression CRM 2011

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.

Upvotes: 8

Views: 19732

Answers (3)

Srinivas Hsk
Srinivas Hsk

Reputation: 398

yes that's right if you want retrieve all all columns means we have to specify the property "true" otherwise we have to customize the column set like ColumnSet ss=new ColumnSet("name","address","gender");

Upvotes: 2

Opt Prutal
Opt Prutal

Reputation: 484

Use this it works in CRM 2015 

query.ColumnSet.AllColumns = true;

and do not set anything in 

query.ColumnSet

Upvotes: 6

Kevin Ross
Kevin Ross

Reputation: 7215

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

query.ColumnSet = new ColumnSet(true);

then it will select all columns

Upvotes: 22

Related Questions