Merge records in LINQ

Question

I am very new into LINQ

I have following 2 queries:

var ticketStatus = from lookup in lookupDetails.AsEnumerable()
                   join ticket in ticketDetails
                       on lookup.LookupDetailID equals ticket.Status
                   select ticket;

var ticketSev = from lookupSev in lookupDetails.AsEnumerable()
                join ticket in ticketDetails
                    on lookupSev.LookupDetailID equals ticket.Status
                select ticket;

var finalTicket = ...

Now I want to merge ticketStatus and ticketSev into finalTicket. How can I achieve this task? I dont want to use Join.

Aren't those two queries exactly the same or am I missing something? — dtb, Dec 15 '11 at 06:28
@dtb: The first query joins `lookup` against `ticket`, while the second one joins `lookupSev` against `ticket`. — Gabe, Dec 15 '11 at 14:29

score 3 · Answer 1 · edited May 23 '17 at 11:53

3

Simple use this to Concatenate and remove duplicate

var finalTicket = ticketStatus.Union(ticketSev);

To Simple concatenation and sort. Duplicates are preserved. use .Concat() on place of .Union()

To implement this in best way follow the following links:
How to: Combine and Compare String Collections (LINQ)
Merging two Collection<T>
Create a list from two object lists with linq

edited May 23 '17 at 11:53

Community

1
1

answered Dec 15 '11 at 06:39

Niranjan Singh

18,017
2
42
75

score 2 · Answer 2 · answered Dec 15 '11 at 06:27

2

var finalTicket = ticketStatus.Union(ticketSev);   // remove duplicates
var finalTicket = ticketStatus.Concat(ticketSev);  // keep duplicates

answered Dec 15 '11 at 06:27

Chris Fulstow

41,170
10
86
110

score 1 · Answer 3 · answered Dec 15 '11 at 06:27

You didn't say how you want to merge them, so I'll assume you want the union of both sets (i.e. combining them and eliminating duplicates):

var finalTicket = ticketStatus.Union(ticketSev);

If you want to keep duplicates or know there won't be any, you can concatenate the sequences instead:

var finalTicket = ticketStatus.Concat(ticketSev);

Merge records in LINQ

3 Answers3