I want to try out with Editor for our .NET MVC project and have queries

I want to try out with Editor for our .NET MVC project and have queries

suneethatechfreaksuneethatechfreak Posts: 4Questions: 1Answers: 0

Hi, I want to try out with Editor for our .NET MVC project. We have complex calculations in the Stored procs to display the data. How we can use editor along with Stored procedures instead of Tables. Can you please help me to understand it

This question has accepted answers - jump to:

Answers

  • colincolin Posts: 15,112Questions: 1Answers: 2,583
    Answer ✓

    Hi @suneethatechfreak ,

    This example here is showing how Editor can be used with a REST interface. If you could create that, with the server then calling the necessary stored procedures, everything should work smoothly.

    Cheers,

    Colin

  • suneethatechfreaksuneethatechfreak Posts: 4Questions: 1Answers: 0

    Thanks Colin for quick response. I'll try it out. Thanks !

  • suneethatechfreaksuneethatechfreak Posts: 4Questions: 1Answers: 0
    edited June 2019

    Hi Colin,

    I have read that Editor will read the data that it is to edit directly from a DataTable, or HTML elements if used in standalone mode.
    But In our current scenario, we get the data from a stored procedure and using read only datatables to display the data. We want to edit the table now, Can you please confirm the possibility of reading the data from stored procs. For submit, we can use Rest interface as you suggested.

    Thanks,
    Suneetha.

  • allanallan Posts: 61,439Questions: 1Answers: 10,053 Site admin
    Answer ✓

    Hi Suneetha,

    The way to use a stored proc. with Editor (for read only) is through a VIEW. You can instruct Editor to read from the VIEW (which you can do just like a table) and your VIEW can read from the stored proc!

    In .NET you would use:

                    var response = new Editor(db, "users")
                .ReadTable("staff_newyork")
    

    Allan

  • suneethatechfreaksuneethatechfreak Posts: 4Questions: 1Answers: 0

    Thanks Allan for the clarification !!

    Thanks,
    Suneetha.

This discussion has been closed.