/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

29 votes321 views4 answers
Show a message box in c#
C#
0 vote360 views1 answer
How to get the ip asp.net mvc
C#
2 votes331 views1 answer
C# gzip byte array
C#
-1 vote315 views2 answers
How to make the player look around in unity 3d
C#
34 votes480 views3 answers
Unity get all by tag
C#Unity
0 vote317 views1 answer
C# linq distinct group by nested list
C#
0 vote315 views2 answers
Lcm of numbers
C#
0 vote333 views1 answer
C# exception middleware
C#
15 votes297 views5 answers
Call function from another script unity
C#
13 votes301 views3 answers
Unity how to move an object
C#