LINQ Dynamic - Distinct

LINQ Dynamic Distinct Examples

C# Dynamic LINQ Distinct examples using an Expression Evaluator.

Distinct - 1

This C# example uses the LINQ Distinct method with a dynamic expression to remove duplicate elements in a sequence of factors of 300.

LINQ

int[] factorsOf300 = {2, 2, 3, 5, 5};

var uniqueFactors = factorsOf300.Distinct();

Console.WriteLine("Prime factors of 300:");
foreach (var f in uniqueFactors)
{
	Console.WriteLine(f.ToString());
}

Try it online

LINQ Execute

int[] factorsOf300 = {2, 2, 3, 5, 5};

var uniqueFactors = factorsOf300.Execute<IEnumerable<int>>("Distinct()");


Console.WriteLine("Prime factors of 300:");
foreach (var f in uniqueFactors)
{
	Console.WriteLine(f.ToString());
}

Try it online

Result

highlight text %} LINQ Execute Test

Prime factors of 300: 2 3 5


## Distinct - 2
This C# example uses the LINQ Distinct method with a dynamic expression to find the unique Category names.

### LINQ
```csharp
var products = getList();

var categoryNames = products.Select(x => x.Category).Distinct();

Console.WriteLine("Category names:");
foreach (var n in categoryNames)
{
	Console.WriteLine(n);
}

Try it online

LINQ Execute

var products = getList();

var categoryNames = products.Execute<IEnumerable<string>>("Select(x => x.Category).Distinct()");

Console.WriteLine("Category names:");
foreach (var n in categoryNames)
{
	Console.WriteLine(n);
}

Try it online

Result

highlight text %} LINQ Execute Test

Category names: Beverages Condiments Produce Meat/Poultry Seafood Dairy Products Confections Grains/Cereals