How to: Remove Duplicate Elements
This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.
This topic provides an example of how to remove duplicate elements from query results by using Distinct. The example uses the *Distinct *method to return the unique country names.
To run the code in this example, you need to create a new Telerik Data Access Domain Model based on the Northwind database.
The following code is the LINQ example.
using ( EntitiesModel dbContext = new EntitiesModel() )
{
IQueryable<string> countries = from customer in dbContext.Customers
select customer.Country;
IQueryable<string> distinctCountries = countries.Distinct();
foreach ( string country in distinctCountries )
{
Console.WriteLine( country );
}
}
Using dbContext As New EntitiesModel()
Dim countries As IQueryable(Of String) = From customer In dbContext.Customers
Select customer.Country
Dim distinctCountries As IQueryable(Of String) = countries.Distinct()
For Each country As String In distinctCountries
Console.WriteLine(country)
Next country
End Using