/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

1 vote168 views1 answer
There is already a virtual axis named Horizontal registered. unity
C#Unity
0 vote149 views2 answers
__dopostback
C#
0 vote237 views1 answer
Unity Rigidbody how to set zero momentum
C#Unity
0 vote131 views1 answer
A infinite loop in text box update ui c#
C#
9 votes138 views3 answers
Switch case with 2 variables c#
C#
0 vote194 views1 answer
C# programtofindthelongestPalindromeinastring.
C#
124 votes351 views6 answers
Git set origin
C#
0 vote146 views1 answer
C# create and populate int list
C#
12 votes151 views2 answers
C# get ip address
C#
18 votes138 views2 answers
Unity remove all child
C#