/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

10 votes136 views2 answers
C# rename file
C#
0 vote180 views1 answer
C# tutorial
C#
0 vote141 views1 answer
Vb.net how insert event inside an event
C#
0 vote134 views1 answer
Can you use unity for ftee
C#
0 vote144 views1 answer
Isselected uicollectionview reused
C#
10 votes136 views2 answers
List<string,string> c#
C#
1 vote172 views2 answers
Generate qr code c#
C#
0 vote139 views1 answer
C# read huge file
C#
0 vote142 views3 answers
How to use multiple Commands for one ViewModel
C#
0 vote151 views1 answer
Selecting multiple columns with linq query and lambda expression
C#