Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums HOW to fetch Unique data from LINQ using the Distinct Method? – MindStick
Ask Question

1 Answers

Ravi Vishwakarma
Ravi Vishwakarma 28 Sep 2021
Report Abuse

In LINQ, the Distinct method or operator is used to get only distinct elements from the collection or list. In another word these distinct method doesn’t accept the duplicate elements, means remove the duplicate value make its single value.

Syntax

collection1.Distinct ( 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', 'India', 'UAE', 'Canada', 'Uk', 'China', 'Pok' };

  // ignore the case

  //List<string> list = count1.Distinct(StringComparer.OrdinalIgnoreCase).ToList();

  List<string> list = count1.Distinct().OrderBy( str => str).ToList();

  list.ForEach( country => Console.WriteLine(country) );

  Console.ReadLine();

 }

}

Output

after using orderby() method result in ascending order

Australia

Canada

China

India

Pok

UAE

Uk

UK

USA
advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md