CODEWITHSUNDEEP
c#linqselectlinq-to-entities
Majid
Majid

Reputation: 14253

Prevent repetitive results in Select statement

I have some beds that are in Room,I want to select all Rooms of my myBeds so I used this LINQ statement:

IEnumerable<Room> rooms= myBeds.Select(b=>b.Room);

but in result there are repetitive Rooms because some rooms may have more than one bed.How can I prevent repetitive Rooms?

Upvotes: 0

Views: 55

Answers (1)

King King
King King

Reputation: 63337

IEnumerable<Room> rooms= myBeds.Select(b=>b.Room).Distinct();

Suppose you have RoomID for your Room, using GroupBy is also OK:

IEnumerable<Room> rooms= myBeds.Select(b=>b.Room)
                               .GroupBy(b=>b.RoomID)
                               .Select(g=>g.First());

Upvotes: 2

Related Questions