/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 vote335 views1 answer
Ubuntu: how to open the terminal from c#
C#
0 vote383 views1 answer
Unity Type of conditional expression cannot be determined because there is no implicit conversion between 'Color' and '<null>'
C#Unity
2 votes285 views2 answers
Asp.net core url parameter
C#
5 votes283 views1 answer
Unity how to get fps c#
C#
0 vote286 views1 answer
How to draw a dot in c#
C#
0 vote270 views1 answer
C# copy each property
C#
0 vote241 views1 answer
How to make a capsule walk in unity
C#
0 vote280 views1 answer
Dotnet.com
C#
4 votes285 views4 answers
Convert foreach to linq c#
C#
2 votes289 views3 answers
Unity remove parent
C#