Linq unique count

Linq unique count property

data.Select(x => x.Id).Distinct().Count();

Source: grepper.com

LINQ return list of unique values with 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;
            }
        }

Source: grepper.com

Similar codes

7 votes334 views2 answers
C# how to check string is number
C#
0 vote330 views1 answer
How to write an if statement with two checkboxes in c#
C#
0 vote380 views1 answer
C# expression func automatically select return type
C#
1 vote343 views1 answer
Regex only letters and numbers c#
C#
2 votes363 views2 answers
C# declare empty string array
C#
0 vote350 views1 answer
Unity pause shortcut
C#
0 vote347 views1 answer
C# get Full Exception message if InnerException is not NULL
C#
0 vote376 views1 answer
C# linq mselect
C#
1 vote349 views1 answer
Protected override void OnExiting(Object sender, EventArgs args) { base.OnExiting(sender, args); Environment.Exit(Environment.ExitCode); }
C#
0 vote354 views1 answer
Unity making homing missile
C#