Convert OData to sql string

Question

Looking for some solution that will help me translate Odata queries to sql syntax string.

Basically I would like to use System.Linq.Dynamic that allows to pass a sql like string to where clause.

I was also trying to use ODataUriParser.ParseFilter that returns AST FilterClause but I do not know how to apply it to an entity framework table to limit results.

Any suggestions?

Probably you are going in wrong direction, take a look at this. learn.microsoft.com/en-us/aspnet/web-api/overview/… Entity Framework already has Odata Context, why not use that one. — loneshark99
– loneshark99, Commented Apr 21, 2017 at 22:26

NetMage · Accepted Answer · 2017-04-21 22:17:36Z

2

Random package found on the Internet :)

DynamicOData

answered Apr 21, 2017 at 22:17

NetMage

27.1k3 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert OData to sql string

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related