Stored procedure returns two tables how to move data from model to view

Question

I have a stored procedure that returns two tables this two tables I store them in two lists example: List<SpObject1> ob1 and List<SpObject2> ob2.

What is the best way to return this data from model to view ? I can create another class(tuple) that can store 2 lists and return them to controller but will this be problem to display on view like this and is it good solution ?

You can use a [ViewModel](https://stackoverflow.com/questions/11064316/what-is-viewmodel-in-mvc) in this scenarios, an example https://stackoverflow.com/a/50509915/2946329 — Salah Akbari, May 31 '18 at 10:48

score 1 · Accepted Answer · answered May 31 '18 at 13:42

You should always try and use ViewModels when returning any data to a view.

Modeling and validating a form with multiple submit

is a good example.

In your controller you will just pass your Lists to that view model and then use the viewModel as a @model.

Stored procedure returns two tables how to move data from model to view

1 Answers1