/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

5 votes191 views2 answers
C# datetime iso 8601 format
C#
4 votes209 views1 answer
Change textbox location C#
C#
7 votes173 views1 answer
Unity change tag in script
C#
7 votes184 views2 answers
Check last character of a string c#
C#
-1 vote192 views1 answer
C# datagridview select row index programmatically
C#
-1 vote186 views1 answer
C# arraylist to listview
C#
39 votes171 views3 answers
C# iterate over a dictionary
C#
5 votes175 views1 answer
C# .net using url
C#
6 votes207 views1 answer
Unity call function on animation onstateexit
C#
-1 vote142 views1 answer
Tsql list tables
C#