/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

7 votes396 views2 answers
Set focus ui unity
C#Unity
2 votes344 views1 answer
C# .net core convert to int round up
C#
6 votes330 views1 answer
Use enter key unity
C#
0 vote339 views2 answers
How to trim path in C#
C#
0 vote401 views1 answer
Unity how to check index of enum
C#
16 votes337 views2 answers
Movetowards unity
C#Unity
0 vote336 views1 answer
Find month number from date C#
C#
1 vote383 views1 answer
Unity2d click on gameobject
C#Unity
0 vote344 views1 answer
Remove header visual studio android
C#
0 vote372 views1 answer
Unity vector3 initialization
C#