Alex Bidule
Alex Bidule

Reputation: 21

.NET web service wrapper for multiple data sources

I am asked to develop (from scratch) a REST web service in .NET that wrapps calls to various data sources:

In the end, we would display this data in web UIs : grid, charts, etc. Other features include: caching, usage monitoring, user roles management. And the idea would be to query this web service with a syntax similar to Open Data.

The data sources configuration would be done in a database, or in a configuration file. Ex: Data source "DS1" is of type "Database" to server "srv001" on database "db001" and gets data from stored procedure "sp001".

Before I start developing that from scratch, I first googled to see if an existing stardard component exists for that. But I couldn't find any.

=> Is there an existing tool on the market that does it out of the box (or close to out of the box) ?

Thank you

Alex

Upvotes: 1

Views: 414

Answers (1)

Rush Frisby
Rush Frisby

Reputation: 11454

There are lots of ways to expose data through a restful interface using .NET

  • For exposing a data source as a service you should use OData.
  • For combining various sources, as you mentioned, as your own mashup service use Web API
  • If your service is only going to be used internally I would use WCF which will be the most performant and easy-to-work-with option.

Upvotes: 1

Related Questions