Community.OData.Linq

Use OData filter text query in linq expresson for any IQuerable. Support web and desktop applications.

Sample

Please check samples below to get started:

.NET Fiddle

https://dotnetfiddle.net/7Ndwot

Console app

    using System;
    using System.Linq;

    using Community.OData.Linq;

    public class Entity
    {
        public int Id { get; set; }

        public string Name { get; set; }
    }

    public static class GetStartedDemo
    {
        public static void Demo()
        {
            Entity[] items =
                {
                    new Entity { Id = 1, Name = "n1" },
                    new Entity { Id = 2, Name = "n2" },
                    new Entity { Id = 3, Name = "n3" }
                };
            IQueryable<Entity> query = items.AsQueryable();

            var result = query.OData().Filter("Id eq 1 or Name eq 'n3'").OrderBy("Name desc").TopSkip("10", "0").ToArray();

            // Id: 3 Name: n3
            // Id: 1 Name: n1
            foreach (Entity entity in result)
            {
                Console.WriteLine("Id: {0} Name: {1}", entity.Id, entity.Name);
            }
        }
    }

ASP.NET Core 2.0

    using System.Linq;

    using Community.OData.Linq;
    using Community.OData.Linq.AspNetCore;

    using Community.OData.Linq.Json;

    using Microsoft.AspNetCore.Mvc;
    using Microsoft.OData;

    using Newtonsoft.Json.Linq;

    public class Entity
    {
        public int Id { get; set; }

        public string Name { get; set; }
    }

    public class ValuesController : Controller
    {
        [Route("/v1")]
        [HttpGet]
        public IActionResult Get(ODataQueryOptions queryOptions)
        {
            if (queryOptions == null && !this.ModelState.IsValid)
            {
                return this.BadRequest(this.ModelState);
            }

            IQueryable<Entity> data = Enumerable.Range(1, 10)
                .Select(i => new Entity { Id = i, Name = $"n{i}" })
                .ToArray()
                .AsQueryable();
            try
            {
                JToken result = data.OData().ApplyQueryOptions(queryOptions).ToJson();
                return this.Ok(result);
            }
            catch (ODataException e)
            {
                return this.BadRequest(e.Message);
            }
        }
    }

Advanced code samples at wiki

https://github.com/IharYakimush/comminity-data-odata-linq/wiki

Supported OData parameters

• $filter
• $orderby
• $select
• $expand
• $top
• $skip

Nuget

• https://www.nuget.org/packages/Community.OData.Linq
• https://www.nuget.org/packages/Community.OData.Linq.Json
• https://www.nuget.org/packages/Community.OData.Linq.AspNetCore

Contribution

Please feel free to create issues and pool requests to develop branch

Build Status

References

Majority of the code was taken from https://github.com/OData/WebApi