Data Access has been discontinued. Please refer to this page for more information.

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

See Also