How do I select distinct values in LINQ query?

By Using LINQ we can read distinct values….LINQ: Read Distinct Record from Data Table

Table of Contents

public JsonResult getEmpCity()
{
using (CompanyDBEntities dc = new CompanyDBEntities())
{
var query = (from p in dc. Emp_Information.
select p. City). ToList();
return new JsonResult.
{

How do you select distinct by one column in LINQ?

Select(x => x. FirstOrDefault()); This will group the table by Text and use the first row from each groups resulting in rows where Text is distinct.

Why distinct is not working in LINQ?

LINQ Distinct is not that smart when it comes to custom objects. All it does is look at your list and see that it has two different objects (it doesn’t care that they have the same values for the member fields). One workaround is to implement the IEquatable interface as shown here.

How does LINQ distinct work?

LINQ Distinct operator removes all the duplicate values from the collection and finally returns the dissimilar or unique values. The LINQ Distinct operator available in only Method Syntax and it not supports the Query Syntax. LINQ Distinct is an operator which comes under Set Operator.

What is distinct method in C#?

C# Linq Distinct() method removes the duplicate elements from a sequence (list) and returns the distinct elements from a single data source. It comes under the Set operators’ category in LINQ query operators, and the method works the same way as the DISTINCT directive in Structured Query Language (SQL).

What is distinct in C#?

Does Linq distinct use equals?

The Distinct(IEnumerable) method returns an unordered sequence that contains no duplicate values. It uses the default equality comparer, Default, to compare values.

What does distinct () do in C#?

How do I SELECT distinct one column?

Adding the DISTINCT keyword to a SELECT query causes it to return only unique values for the specified column list so that duplicate rows are removed from the result set. Since DISTINCT operates on all of the fields in SELECT’s column list, it can’t be applied to an individual field that are part of a larger group.

How does SELECT distinct work?

A SELECT DISTINCT statement first builds our overall result set with all records, i.e including duplicate values based on FROM, JOIN, WHERE, HAVING, etc statements. Next, it sorts the result set based on the column_name or field with which DISTINCT has been used.

What is distinct method?

The Distinct(IEnumerable) method returns an unordered sequence that contains no duplicate values. It uses the default equality comparer, Default, to compare values. In Visual Basic query expression syntax, a Distinct clause translates to an invocation of Distinct.