/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 vote226 views1 answer
Celsius to Fahrenheit c#
C#
0 vote187 views1 answer
How do you search for how many times a character appears in user input on c sharp
C#
0 vote165 views1 answer
How to check if bool is true c#
C#
120 votes550 views6 answers
C# math random
C#
1 vote207 views1 answer
Unity c# how to restart the level
C#Unity
9 votes137 views2 answers
Cast int as enum c# microsoft
C#
3 votes166 views2 answers
C# and
C#
2 votes240 views1 answer
Object spin unity
C#Unity
2 votes158 views1 answer
C# throw exception
C#
1 vote180 views1 answer
How to create empty ui object unity
C#