How do I merge two seperate '.ToList()"?

Question

There are several posts where people are asking how to merge generic lists. However, in my case I have two seperate linq statements where I am returning two separate database results .ToList()

var appleList = (from al in db.Apples where al.Id == id select al).ToList();
var bananaList = (from bl in db.Bananas where bl.Id == id select bl).ToList();

I tried merging these list like so:

appleList.Concat(bananaList);

but this causes the following error:

'List' does not contain a definition for 'Concat'

How do I combine these two .ToList()?

when I do that it says `cannot convert from System.Collections.Generic.List to System.Collections.Generic.IEnumerable` — Skullomania, Sep 19 '20 at 15:33
@SowmyadharGourishetty Presumbably `Apple` and `Banana` are different types. You can't add instances of two different types into the same List, unless the List is some common supertype. — derpirscher, Sep 19 '20 at 15:35
@Skullomania, My bad, I didn't see they are of 2 different types. You cannot merge in your case, as they are of different types — Sowmyadhar Gourishetty, Sep 19 '20 at 15:39

score 0 · Answer 1 · answered Sep 19 '20 at 15:42

0

Create a fruit class and derive both apples and bananas from it.

https://www.webopedia.com/TERM/B/base_class.html

answered Sep 19 '20 at 15:42

James Leshko

173
1
3
16

How do I merge two seperate '.ToList()"?

1 Answers1

Linked