Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 756
  • Last Modified:

Architecture Question

Application Design Guidance :

Requirements :

Has to be REST Based Service.

Retrieving data from Oracle Database.

Columns in select can change and are configurable after the deployment (Thinking of query store where we can store oracle selects and retrieving them before firing off to back end. Advise needed if there are any design patterns that can solve this)

Whole select statements and where clause  should be configurable (in XML file or Database) there will be parameters that will replace in where.

Data is shown in the grid by the consumer (sharepoint web part, webform, windows forms etc., depends on the use)

Advise on the design pattern that i can use.

Important is the REST based service , is it good (performance wise) to return a data table form rest based service. I do not want to use strongly typed data sets because whole selects are configurable.

1 Solution
Jaime OlivaresSoftware ArchitectCommented:
As you need flexibility in the column name for your selects, I would suggest OData, which is a Microsoft open implementation based on the REST architectural framework.
OData allows complex and flexible query strings like:
http://yourdomain.com/service.svc/Items?$filter=startswith(Name, 'Sea')

Open in new window

Have a look at:
OData overview: http://www.odata.org/documentation/overview
URI conventions: http://www.odata.org/documentation/uri-conventions
Oracle specifics: http://download.oracle.com/oll/obe/EntityFrameworkWCF/WCFEntityFramework.htm
NetSriAuthor Commented:

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now