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.

Who is Participating?
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:$filter=startswith(Name, 'Sea')$top=2&$orderby=name

Open in new window

Have a look at:
OData overview:
URI conventions:
Oracle specifics:
NetSriAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.