Oqtane Tutorials
Oqtane Tutorials

LINQ Tutorial (Language INtegrated Query)

Tutorial Home › LINQ
Use DNN APIs to get DNN Data
#1 LINQ Basics
LINQ Relationships - Children, Parents, Grandchildren, ...
Resources

LINQ Basics

Learn how to leverage LINQ (Language Integrated Query) of C# to sort, filter, group content-items. This demo uses the following data in app:

  • Persons - various people who are used in the data. A person can also have one or many favorite books.
  • Books - books people wrote or contributed to. Books have authors and
The samples can differ based on your Razor base class or if you're running an old version.
Switch to Typed (2sxc 16+) Switch to Dynamic (Razor14 or below)

Simple Where(...) and Any()

This filters the authors to only find Terry.

⬇️ Result | Source ➡️

  1. Terry Pratchett
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  // Initial Code
  var persons = AsItems(App.Data.GetStream("Persons"));
}
<ol>
  @foreach (var person in persons
  .Where(p => p.String("FirstName") == "Terry")) 
  {
    <li>@person.Get("FirstName") @person.Get("LastName")</li>
  }
</ol>

This filters the authors with long first names.

⬇️ Result | Source ➡️

  1. Douglas Adams
  2. George Akerlof
  3. Raphael Müller (not an author)
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  // Initial Code
  var persons = AsItems(App.Data.GetStream("Persons"));
}  
<ol>
  @foreach (var person in persons
  .Where(p => p.String("FirstName").Length > 5)) 
  {
    <li>@person.Get("FirstName") @person.Get("LastName")</li>
  }
</ol>

This filters the authors with long first names.

⬇️ Result | Source ➡️

  1. Persons with 5-char names or more: True
  2. Persons with 10-char names or more: False 
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  // Initial Code
  var persons = AsItems(App.Data.GetStream("Persons"));
}
<ol>
  <li>
    Persons with 5-char names or more: 
    @persons.Any(p => p.String("FirstName").Length > 5)
  </li>
  <li>
    Persons with 10-char names or more: 
    @persons.Any(p => p.String("FirstName").Length > 10)
  </li>
</ol>

Simple First() and Last()

This filters the authors with long first names.

⬇️ Result | Source ➡️

  1. First: Douglas
  2. Last: Ed 
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  // Initial Code
  var persons = AsItems(App.Data.GetStream("Persons"));
}
<ol>
  <li>
    First: @persons.First().Get("FirstName")
  </li>
  <li>
    Last: @persons.Last().Get("FirstName")
  </li>
</ol>

Take() / Skip()

Take the first three authors.

⬇️ Result | Source ➡️

  1. Douglas Adams
  2. Terry Pratchett
  3. Neil Gaiman
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  var persons = AsItems(App.Data.GetStream("Persons"));
  var books = AsItems(App.Data.GetStream("Books"));
}
<ol>
  @foreach (var person in persons.Take(3)) {
    <li>@person.Get("FirstName") @person.Get("LastName")</li>
  }
</ol>

Skip the first three authors.

⬇️ Result | Source ➡️

  1. George Akerlof
  2. Raphael Müller (not an author)
  3. Ed Hardy
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  var persons = AsItems(App.Data.GetStream("Persons"));
  var books = AsItems(App.Data.GetStream("Books"));
}
<ol>
  @foreach (var person in persons.Skip(3)) {
    <li>@person.Get("FirstName") @person.Get("LastName")</li>
  }
</ol>

Skip the first three authors, then take 2.

⬇️ Result | Source ➡️

  1. George Akerlof
  2. Raphael Müller (not an author)
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  var persons = AsItems(App.Data.GetStream("Persons"));
  var books = AsItems(App.Data.GetStream("Books"));
}
<ol>
  @foreach (var person in persons.Skip(3).Take(2)) {
    <li>@person.Get("FirstName") @person.Get("LastName")</li>
  }
</ol>

Count() and Count

Count some stuff.

⬇️ Result | Source ➡️

  1. All Persons: 6
  2. All Books: 4
  3. Books with Illustrators: 1) 
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
// Initial Code
  var persons = AsItems(App.Data.GetStream("Persons"));
  var books = AsItems(App.Data.GetStream("Books"));
}
<ol>
  <li>
    All Persons: @persons.Count()
  </li>
  <li>
    All Books: @books.Count()
  </li>
  <li>
    Books with Illustrators:
    @books.Where(b => b.Children("Illustrators").Count() > 0).Count())
  </li>
</ol>

Simple Sorting of Persons

This example shows A-Z ordering by a property which exists on all entities: EntityId

⬇️ Result | Source ➡️

  1. Douglas Adams (#5338)
  2. Terry Pratchett (#5339)
  3. Neil Gaiman (#5340)
  4. George Akerlof (#5344)
  5. Raphael Müller (not an author) (#5348)
  6. Ed Hardy (#5349) 
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  var persons = AsItems(App.Data.GetStream("Persons"));
}
<ol>
  @foreach (var person in persons
    .OrderBy(p => p.Id)) 
  {
    <li>@person.Get("FirstName") 
      @person.Get("LastName") (#@person.Id)
    </li>
  }
</ol>

This example shows A-Z ordering by a property which exists only on Person-entities. This is simple with dynamic objects

⬇️ Result | Source ➡️

  1. Douglas Adams
  2. Ed Hardy
  3. George Akerlof
  4. Neil Gaiman
  5. Raphael Müller (not an author)
  6. Terry Pratchett
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
  var persons = AsItems(App.Data.GetStream("Persons"));
}
<ol>
  @foreach (var person in persons
  .OrderBy(p => p.String("FirstName"))) 
  {
    <li>@person.Get("FirstName") @person.Get("LastName")</li>
  }
</ol>

This example shows Z-A ordering by a property.

⬇️ Result | Source ➡️

  1. Raphael Müller (not an author) (3/1/2000)
  2. Neil Gaiman (11/10/1960)
  3. Douglas Adams (3/11/1952)
  4. Terry Pratchett (4/28/1948)
  5. Ed Hardy (1/1/1945)
  6. George Akerlof (6/17/1940) 
@inherits Custom.Hybrid.RazorTyped
@using System.Linq

@{
   var persons = AsItems(App.Data.GetStream("Persons"));
}
<ol>
  @foreach (var person in persons
    .OrderByDescending(p => p.DateTime("Birthday"))) 
  {
    <li>@person.Get("FirstName") @person.Get("LastName") 
      (@person.DateTime("Birthday").ToString("d"))
    </li>
  }
</ol>

 

 

Use DNN APIs to get DNN Data
#1 LINQ Basics
LINQ Relationships - Children, Parents, Grandchildren, ...