Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Distinct Value from Linq Query

Tags:

c#

wpf

I have the below class and linq query I am using to populate a grid!

The Title is the same for every row returned. What I am trying to do is populate mString with the distinct Title from the query so I can bind it to a seperate textblock.

I probably didnt need to show all the code, but maybe it will help. How can I show the distinct Title.

public class Items
{
    public int Id { get; set; }
    public string Details { get; set; }
    public string Title { get; set; }
    public int NewNumber { get; set; }
}

private ObservableCollection<Items>  mItem = new ObservableCollection<Items>();
private string mString = string.Empty;

public string SpecTitle
{
    get { return mString; }
}

public ObservableCollection<Items> GetItems
{
    get { return mItem; }
}

Here is the linq query

var results = (from z in mContext.View
               orderby z.ItemNumber ascending
               where z.ItemId == mId
               select new Items()
               {                                         
                   Id = z.ItemId,
                   Details = z.Details,
                   Title = z.ItemTitle,
                   NewNumber = z.ItemNumber
               });

List<Items> mNewItems = results.ToList();
mItem.Clear();
mNewItems.ForEach(y => mItem.Add(y));
like image 839
KeyboardFriendly Avatar asked Dec 17 '25 19:12

KeyboardFriendly


1 Answers

var titleList = mNewItems.Select(i => i.Title).Distinct().ToList();
like image 115
Adriano Carneiro Avatar answered Dec 20 '25 10:12

Adriano Carneiro



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!