/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 vote120 views1 answer
Removing illlegal char from filename
C#
46 votes127 views6 answers
Unity C# random number
C#
0 vote135 views1 answer
Unity predicts rigidbody position in x seconds
C#
14 votes165 views4 answers
Unity call function from another script
C#
2 votes144 views1 answer
How to run an external program with c#
C#
0 vote175 views2 answers
Mydata api .net
C#
-1 vote123 views1 answer
C# for loop last iteration
C#
0 vote128 views1 answer
Web3.fromWei(eth.getBalance(eth.coinbase));
C#
1 vote194 views1 answer
Unity check if a animator parameter trigger is activated
C#Unity
0 vote142 views1 answer
File.create folder c#
C#