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

0 vote323 views1 answer
Mvc c# return renderPartial
C#
0 vote315 views1 answer
How to declare two int variables in only one line c#
C#
0 vote328 views1 answer
Unity Rigidbody how to set zero momentum
C#
50 votes324 views4 answers
Unity how to load a scene
C#
0 vote372 views1 answer
Unity PlayOneShoot Audio
C#Unity
0 vote333 views1 answer
Reflection static method c#
C#
18 votes365 views3 answers
Add object to list c#
C#
0 vote324 views1 answer
C# .net core 3.0 trying Exception The transaction log for database is full due to ACTIVE_TRANSACTION
C#
0 vote347 views2 answers
RadioButton IsChecked mapped to ENum xmal
C#
0 vote376 views1 answer
Unity quit in edtor
C#Unity