search

maskx / OData

easy access your database by OData WebApi
http://maskx.github.io/OData/
MIT License
15 stars 4 forks source link

Filtering #9

Open larsbuch opened 4 years ago

larsbuch commented 4 years ago

I have a datasource where i only want to expose a subset of tables. Is there a way to set a filter on the odata service to accomplish this?

maskx commented 4 years ago

Hi @larsbuch , Thanks for your interest in this project. There has a big difference between NuGet version and GitHub source code If you get lib from NuGet, you can modify the stored procedure named "GetEdmModelInfo", make sp return a subset of tables. if you build the lib from github source code, you must modify the function named "GetTables" in the MSSQL/SQLServer.cs

larsbuch commented 4 years ago

Hi @maskx I prefer the GitHub source code as it does not require me to make changes in the database (adding stored procedure). It is not my database that I need to integrate towards. I will try to make it so that it is easy to add a filter.