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

1 vote170 views1 answer
How to delete multiple file by datagridview in c#
C#
0 vote133 views1 answer
Händelsereportage
C#
0 vote192 views1 answer
Mac osx enable hidpi terminal
C#
0 vote169 views1 answer
How to set a tag in asp net razor view stackoverflow
C#
11 votes146 views1 answer
Mouse 2d unity
C#
0 vote210 views1 answer
SerializedObjectNotCreatableException: Object at index 0 is null
C#
1 vote135 views2 answers
Lerp c#
C#
0 vote229 views1 answer
C# double to string with dot
C#
0 vote186 views1 answer
Sto playing audiosource
C#
1 vote166 views1 answer
C# how to simulate mouse click
C#