2. Filter

Usings

    using System;
    using System.Linq;

    using Community.OData.Linq;

Filter by simple properties

Code

    IQueryable<Sample> dataSet = Sample.CreateQuerable();
    Sample[] filterResult = dataSet.OData().Filter("Id eq 2 or Name eq 'name3'").ToArray();

    foreach (Sample sample in filterResult)
    {
        Console.WriteLine(string.Format("Id:{0} Name:{1}", sample.Id, sample.Name));
    }

Console output

Id:2 Name:name2
Id:3 Name:name3

Filter by related entity

Code

    IQueryable<Sample> dataSet = Sample.CreateQuerable();
    Sample[] filterResult = dataSet.OData().Filter("RelatedEntity/Id eq 10").ToArray();

    foreach (Sample sample in filterResult)
    {
         Console.WriteLine(string.Format("Id:{0} Name:{1}", sample.Id, sample.Name));
    }

Console output

Id: 1 Name: name1