/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

4 votes124 views1 answer
Bitmask c#
C#
0 vote151 views1 answer
Free unity mouse look
C#Unity
0 vote117 views1 answer
Wpf app how to get all elements
C#
0 vote130 views1 answer
Section in inspector unity
C#Unity
0 vote120 views1 answer
'Using a Hub instance not created by the HubPipeline is unsupported.'
C#
0 vote108 views1 answer
Afaik
C#
0 vote131 views2 answers
How to encode and decode a string in c#
C#
0 vote115 views2 answers
Difference between eager and lazy loading entityframwork
C#
0 vote143 views1 answer
Unity gun clipping through walls
C#Unity
2 votes108 views1 answer
Unity 2d how to set an object or the mouse position
C#