How to send LINQ query to a View without using ViewModel

Question

I can use a ViewModel and pass my LINQ Query through it to the View with @model directive as @model IEnumerable<MyWebProject.ViewModels.MyViewModel>. Question: But, 1. What if I don't want to use a View Model in the following example: 2. What would be my @model directive in that case?

ViewModel:

public class MyViewModel
{
    public string CustomerName{ get; set; }
    public int CustomerOrderNo{ get; set; }
}

Controller:

public ActionResult Index()
{
    MyViewModel vm= new MyViewModel();
    var vm = (from c in db.Customers
             join o in db.Orders
             select new { CustomerName = c.Name, CustomerOrderNo = o.OrderNo}).ToList();
            return View(vm);
}

View:

@model IEnumerable<MyWebProject.ViewModels.MyViewModel>
@foreach (var item in Model)
{
    <tr>
        <td>
            @Html.DisplayFor(modelItem => item.CustomerName)
        </td>
        <td>
            @Html.DisplayFor(modelItem => item.CustomerOrderNo)
        </td>
    </tr>
}

you should'nt do that, use viewmodel, why you don't want to use it? — Ehsan Sajjad
– Ehsan Sajjad, Commented Aug 29, 2016 at 20:13
Your linq expression returns a collection of anonymous objects. You cannot bind your view to that. You should create and use a view model/DTO — Shyju
– Shyju, Commented Aug 29, 2016 at 20:15
Hardcoded viewmodels always good way to implement a view, if you do not have an exact irregular situation. — Cihan Uygun
– Cihan Uygun, Commented Aug 29, 2016 at 20:20

teo van kot · Accepted Answer · 2016-08-29 20:48:54Z

0

You always can use Tuple. Like this:

public ActionResult Index()
{
    MyViewModel vm= new MyViewModel();
    var vm = (from c in db.Customers
             join o in db.Orders
             select new Tuple<string, int>(c.Name, o.OrderNo).ToList();
            return View(vm);
}

And on View:

@model IList<Tuple<string, int>>

You can access it like this:

@foreach (var item in Model)
{
    @Model.Item1
}

But DON'T DO IT, PLEASE.

answered Aug 29, 2016 at 20:48

teo van kot

12.5k10 gold badges40 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

nam Over a year ago

You also seem to be using ViewModel shown in you Index() method above. Did you mean vm not as a YmVievModel() class instance variable - instead just a variable for the LINQ Query?

teo van kot Over a year ago

@nam that's not ViewModel actually. It's Tuple

nam Over a year ago

I see - thanks. MyViewModel vm= new MyViewModel(); line is not used.

Gert Arnold Over a year ago

Now Tuple is the view model. What's in a name?

Ivan Stoev Over a year ago

Are you sure about "You always can use Tuple". EF requires parameterless constructors and property setters, hence does not support projecting to Tuples. See for instance Create a Tuple in a Linq Select.

Collectives™ on Stack Overflow

How to send LINQ query to a View without using ViewModel

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related