/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 vote376 views1 answer
Freeze scene unity
C#Unity
0 vote322 views2 answers
System.Data.SqlClient.SqlException: 'Execution Timeout Expired.
C#
1 vote348 views1 answer
Vscode not showing errors c#
C#
-1 vote316 views3 answers
Google tradutor
C#
11 votes359 views1 answer
C# How to write Hello World
C#
1 vote373 views4 answers
Check if a string is a palindrome
C#
0 vote346 views1 answer
Moq set delay to return
C#
0 vote357 views1 answer
Asp.net core mvc not triggering client side validation
C#
2 votes345 views1 answer
Dotnet ef install global
C#
9 votes316 views1 answer
Unity car controller script c# download
C#