Assign Distinct Object/Class in Linq to objects

Question

I am doing following and it works:

    var resultsHeader = (from r in o select new { 
                        OrderID  = r.OrderID,
                        subtotal = r.SubTotal,
                        city = r.orderAddress.BilltoCity
    }).Distinct().ToList();

Look at the city = r.orderAddress.BilltoCity Line, is there any way i can populate the entire object there...like this

var resultsHeader = (from r in o select new { 
                    OrderID  = r.OrderID,
                    subtotal = r.SubTotal,
                    Address = r.orderAddress
}).Distinct().ToList();

Basicly, I want to store entire OrderAddress Object into Address property, however it does not come out as Distinct object.

Is it LINQ to Objects? Is it LINQ to SQL? Is it LINQ to Entities? — MarcinJuraszek, Mar 19 '14 at 03:49

score 1 · Accepted Answer · edited May 23 '17 at 10:26

1

You can either use DistinctBy from moreLINQ:

var resultsHeader = (from r in o select new { 
                    OrderID  = r.OrderID,
                    subtotal = r.SubTotal,
                    city = r.orderAddress.BilltoCity
}).DistinctBy(x => new { x.OrderID, x.subtotal }).ToList();

or GroupBy, which is part of LINQ already:

var resultsHeader = (from r in o
                     group r by new { r.OrderIs, r.SubTotal } into g
                     select new {
                         g.Key.OrderID,
                         g.Key.SubTotal,
                         Address = g.First().orderAddress
                     }).ToList()

UPDATE

Or, you can implement Equals and GetHashCode on your Address class and use Distinct as you do now.

edited May 23 '17 at 10:26

Community

1
1

answered Mar 19 '14 at 03:52

MarcinJuraszek

124,003
15
196
263

don't really want to use any other library, could it be possible without it? if i copy all the properties of Address objects then Distinct works just fine...its just when i pass the whole object it does not. – highwingers Mar 19 '14 at 03:54
`GroupBy` does not require any additional library. – MarcinJuraszek Mar 19 '14 at 03:55
any example using Equalls? – highwingers Mar 19 '14 at 04:00

Assign Distinct Object/Class in Linq to objects

1 Answers1