/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

0 vote171 views1 answer
How to check if every element in array is true c#
C#
0 vote164 views2 answers
Wpf datagrid get selected items
C#
1 vote170 views1 answer
In Asp.Net Core core how to I get the web site's IP address?
C#
3 votes182 views2 answers
C# open file
C#
1 vote167 views1 answer
Unity key up
C#
0 vote172 views1 answer
C# reflection get property value array
C#
0 vote210 views1 answer
How to lerp a value in unity
C#Unity
11 votes179 views3 answers
C# get all enum values
C#
0 vote183 views1 answer
Get sha1 hashcode from c#
C#
4 votes162 views2 answers
C# delete files older than 10 days
C#