/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

0 vote284 views1 answer
Why Duplicate "..TargetFrameworkAttribute" c# assemblies created
C#
7 votes280 views1 answer
For loop unity
C#Unity
0 vote285 views2 answers
C# get pixel color from image
C#
2 votes273 views1 answer
How to run an external program with c#
C#
5 votes308 views2 answers
Rigidbody velocity c# unity
C#Unity
0 vote308 views1 answer
Asp.net render control to string
C#
0 vote285 views1 answer
C# press ctrl and alt
C#
1 vote295 views1 answer
Convert array object to int[] c#
C#
0 vote261 views1 answer
How to change the color of a textbox with button c#
C#
0 vote275 views1 answer
Make character move upward forever unity 2d
C#