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

suneethatechfreak

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

colin

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

suneethatechfreak

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

suneethatechfreak

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.

allan

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

suneethatechfreak

Thanks Allan for the clarification !!

Thanks,
Suneetha.