/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 vote163 views2 answers
C# download image from url
C#
1 vote220 views1 answer
C# datagridview change column name
C#
6 votes204 views1 answer
Unity call function on animation end
C#
33 votes218 views2 answers
C# array of strings
C#
0 vote205 views2 answers
C# wpf control to windw size
C#
1 vote196 views1 answer
C# get count from unknown list
C#
1 vote235 views1 answer
C# get next item in list
C#
3 votes169 views1 answer
Winforms textbox placeholder
C#
0 vote238 views1 answer
How to access path position variable in unity
C#Unity
0 vote190 views1 answer
<select name="countries" > <?php while ($row = $result Set->fetch_assoc()) { $country = $roads['country']; echo "<option value='$country'> $country </option>"; } ?> </select>
C#