Answer the question
In order to leave comments, you need to log in
How to implement OData "calculate on fly" Tables?
I am developing a service using ASP.NET + MSSQL DB.
The essence of the problem:
I need to refer to specific tables using the OData standard and make a selection from them.
How, for example, to work with the Student table in the request http://localhost:[port]/api/values/student to get all the records of the table.
The examples on the web create controllers by explicitly specifying the table:
public IQueryable Get ()
{
return _ctx.Student.AsQueryable ();
}
But the problem is that I don't know what tables will be in the database. Their creation is meant even after writing the service.
How to implement so that the user writes a query to the table, and on my part it has already been checked whether it exists at all and then work has already been done with it?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question