2. Filter

Usings

using OData2Linq;
using System;
using System.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