Linq Unique list ?

I am trying to get a list of unique ISBN as such
Dim ISBNs = From row In dt Select row.Field(Of String)("ISBN").Distinct
But it is returning all including duplicates. What am doing wrong?

Visual Basic.NET.NET Programming

Last Comment

kaufmed

8/22/2022 - Mon

Fernando Soto

9/15/2016

Try it like this.[code]Dim ISBNs = (From row In dt
Select row.Field(Of String)("ISBN"))ToList()..Distinct()[/code]

ASKER CERTIFIED SOLUTION

it_saige

9/15/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

kaufmed

9/15/2016

You can also make use of the morelinq library's DistinctBy method:

Dim ISBNs = dt.Rows.DistinctBy(Function (row) row.Field(Of String)("ISBN"))

Open in new window

You can install morelinq via NuGet.

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Certified Expert Program

Credly Partnership

Udemy Partnership