ODataQueryOptions to Sql Query

[rbalagangadharan]

Hi,
I am working on a project, where my tables are not fixed. The user can create tables and insert data. For this use case we used ODataDynamicModel

With this we created the Dynamic Edm models on runtime. Now my question is, how to convert the QueryOptions like $select, $filter, $expand and other OData Options to Sql Query?

We used this library DynamicODataToSql to convert odata to sql, but it has some limitations.

Any help on this would be really appreciated.

Thanks

[rbalagangadharan]

@xuzhg Can you share any ideas to achieve this.

[rbalagangadharan]

@xuzhg @gathogojr Can you please let me know whether this is possible or not?

[rbalagangadharan]

@xuzhg Can you please update on this?