/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

4 votes106 views1 answer
How to stop window from terminating c# visual studio
C#
0 vote132 views1 answer
Log4net.config configuration
C#
3 votes103 views1 answer
C# read text file to list string
C#
0 vote96 views1 answer
Unity keep screen always on
C#
0 vote103 views1 answer
Convert number of days into months c#
C#
7 votes96 views2 answers
Insert variables into a string C#
C#
1 vote142 views1 answer
Look rotation only on y axis in unity
C#Unity
0 vote139 views1 answer
C# sprint key
C#
2 votes104 views2 answers
Convert list to ienumerable
C#
14 votes147 views2 answers
How to make multiplayer game in unity
C#Unity