News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to convert retriev...

Microsoft Dynamics CRM (Archived)

How to convert retrieved records to list and group

(0) Share

Report

Report

Posted on by NKC

4,440

Hi

After retrieving records how do i convert to list and group. Basically i am retrieving records want to group by owners.

foreach (Entity ent in EC.Entities)
{
string subject = ent["name"].ToString();
string SR_Number = ent["number"].ToString();
EntityReference originator = (EntityReference)ent.Attributes["originator"];
string originatorname = originator.Name;
EntityReference ownerid = (EntityReference)ent.Attributes["ownerid"];
string ownername = ownerid.Name;

}

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Nithya Gopinath 17,074 on at

Like (0)

Report
RE: How to convert retrieved records to list and group

Hi Krish,

In order to convert these retrieved records to a list, just try the code below.

EC.Entities.ToList()

For grouping, this by owner, try the LINQ query below.

var linqQuery2 = (from ent in EC.Entities.ToList() group ent by ent.OwnerId into myGroup select new { OwnerName = myGroup.First().OwnerName, OrderCount = myGroup.Count() });

See: http://stackoverflow.com/questions/7642365/using-group-in-linq-query

Hope this helps.
Suggested answer

ashlega 34,475 on at

Like (0)

Report

RE: How to convert retrieved records to list and group

Hi Krish,

EC.Entities.ToList() would give you a list.

For grouping.. Have a look here:

stackoverflow.com/.../using-linq-to-group-a-list-of-objects-into-a-new-grouped-list-of-list-of-objects

I think it would translate to this:

var groupedByOwnerId = EC.Entities.ToList().GroupBy(e =>

((EntityReference)e["ownerid"]).Id)

.Select(grp => grp.ToList())

.ToList();

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans