How to expose data from database to be queryable?

Question

I need to design a wrapper around a few database tables, allowing the client to simply execute a GET:

http://myservice/accounts?$filter=name eq alex

And then this service will apply that query against a database table like:

create table account (name varchar, key int)

We would have some controller that would grab that query string and apply it against the dataset, in pseudocode:

public class AccountsController
{
   public HttpResponseMessage Get()
   {
        return _dataSource.Get(Request.ODataQueryString);
    }
}

How do we expose a sql server table to be easily queryable via odata?

dperish · Accepted Answer · 2017-11-16 21:09:21Z

3

Assuming you're using EntityFramework, you'd just need to register your controller as an OData endpoint, decorate it with the OData [EnableQuery] attribute and return an instance of the class you're targeting via your controller method:

https://learn.microsoft.com/en-us/aspnet/web-api/overview/odata-support-in-aspnet-web-api/odata-v4/create-an-odata-v4-endpoint

edited Nov 16, 2017 at 21:09

answered Oct 31, 2017 at 17:56

dperish

1,57117 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

How to expose data from database to be queryable?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related