Architecture Question

Posted on 2012-08-31
Last Modified: 2012-08-31
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.

Question by:NetSri
    LVL 55

    Accepted Solution

    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:

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
    Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
    Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now