/C#/C# list of unique values with group and counts

C# list of unique values with group and counts

// model
 public class orderviewmodel
    {
        public string OrderNumber { get; set; }
        public int Count { get; set; }
    }
    
 // BL
  public IList<orderviewmodel> Read(string tmpC)
        {
            try
            {
                using (var entities = new UrEntities())
                {
                    return entities.Masters.Where(w => w.ContainerNumber.Equals(tmpC)).GroupBy(g => g.OrderNumber)
                        .Select(s => new orderviewmodel { OrderNumber = s.Key, Count = s.ToList().Count,  }).ToList();
                }
            }
            catch (Exception)
            {

                throw;
            }
        }

Similar codes

3 votes246 views2 answers
C list add element
C#
5 votes262 views2 answers
C# download file
C#
0 vote295 views1 answer
@using System,System.Core
C#
1 vote259 views1 answer
Ensuresuccessstatuscode exception
C#
1 vote253 views2 answers
Remove items from one list in another c#
C#
0 vote296 views2 answers
Context.Response.Body read stream .net
C#
1 vote250 views2 answers
Huidige timestamp c#
C#
6 votes299 views1 answer
The hidden dungeon only i could enter season 2
C#
0 vote266 views1 answer
Get web api relative path
C#
0 vote214 views1 answer
Acrylic UWP Title bar C#
C#