Light switch get data from Sql Stored Procedure RRS feed

  • Question

  • HI

    Can any one help me how to expose the data in Light switch Odata service using SQL Stored Procedures.

    My Requirement is as follows.

    I have 2 tables emp and dept .

    I have a stored procedure that will get the data from the above 2 tables .

    I want to use this stored procedure in light switch and expose the data.

    Kindly help me



    Monday, April 6, 2015 12:30 PM

All replies

  • Hi,
    a first ""How to do" is explained in this article.

    Hope this helps.

    Kind Regards


    Monday, April 6, 2015 8:01 PM
  • HI

    Thanks for your valuable inputs.

    Some how (may be I am wrong) the above example is not helpful to me.

    I want to use the external database and a stored procedure with in the external database.

    my requirement is as follows

    I have 2 tables emp and dept .

    I have a  stored proc get_empDetails() and data has to be expose as Odata service.

    my requirement is I want to expose the data return by storedproc as odata service.

    please kindly help me.

    Thanks and Regards


    Tuesday, April 7, 2015 1:14 PM