CODEWITHSUNDEEP
c#entity-frameworklinq
Arif YILMAZ
Arif YILMAZ

Reputation: 5866

How to convert Anonymous Type to Strong Type from LINQ query

I have written a LINQ query which returns a new type of class, becuse I have used GROUP BY. Therefore, I have created a new class to cast Anonymous type to Strong Type. Here is my LINQ...

var result = rpt
    .GroupBy(x => new
                  {
                      CreateTime = EntityFunctions.TruncateTime(x.CreatedTime),
                      x.UserId,
                      x.ProjectId
                  })
    .Select(x => new
                 {
                     UserId = x.Key.UserId,
                     ProjectId = x.Key.ProjectId,
                     CreateTime = x.Key.CreateTime,
                     TotalMinutesSpent = x.Sum(z => z.MinutesSpent)
                 })
    .OfType<List<UserTransactionReport>>().ToList();

My newly created class is like below...

public class UserTransactionReport
{
    public int UserId { get; set; }
    public int ProjectId { get; set; }
    public DateTime CreateTime { get; set; }
    public int TotalMinutesSpent { get; set; }
}

How can I convert this anonymous to strong?

Upvotes: 5

Views: 9979

Answers (1)

Alexander Derck
Alexander Derck

Reputation: 14498

You can create strongly typed objects in the select:

List<UserTransactionReport> result = 
    ...
    .Select(x => new UserTransactionReport
    {
       UserId = x.Key.UserId,
       ProjectId = x.Key.ProjectId,
       CreateTime = x.Key.CreateTime,
       TotalMinutesSpent = x.Sum(z => z.MinutesSpent)
    }).ToList();

Upvotes: 20

Related Questions