forum

Home / DeveloperSection / Forums / How to fetch data using Union method in LINQ?

Ask Question

How to fetch data using Union method in LINQ?

Ethan Karla 358 24-Sep-2021

How to fetch data using the Union method from two lists?

linq c#  ado.net  linq 
Updated on 24-Sep-2021
Ethan Karla

Ethan Karla

Follow
An enthusiastic, adaptive, and fast-learning person with a broad and acute interest in the discovery of new innovative drugs, I particularly enjoy collaborating with scientists from different disciplines to develop new skills and solve new challenges.

Can you answer this question?

Answer

1 Answers

Ravi Vishwakarma

Ravi Vishwakarma

28-Sep-2021

The Union method or operator is used to combine multiple collections or lists into a single collection or list and return collection with unique elements.

Syntax

var result = collection1.Union(collection2)

Example 

using System;
using System.Collections.Generic;
using System.Linq;
public class Program
{
 public static void Main()
 {
  List<string> count1= new List<string>() { 'UK', 'Australia', 'India', 'USA' };
  List<string> count2 = new List<string>() { 'India', 'UAE', 'Canada', 'UK', 'China', 'Pok' };
  List<string> list = count1.Union(count2).ToList();
  list.ForEach( country => Console.WriteLine(country) );
  Console.ReadLine();
 }
}

Output

UK

Australia

India

USA

UAE

Canada

China

Pok

Liked By