Select By Key Values from a LINQ Query in a view

Question

I am trying to grab each key value from a LINQ Query and pull them into my view. The LINQ query looks like this:

Public Property ByVDN As IEnumerable
    Get
        Dim valQ = (From scr In Var.db.CareSideA.ScriptCrossReferences
                   Join s In Var.db.CareSideA.Scripts On s.ScriptID Equals scr.ScriptID
                   Join ms In Var.db.CareSideA.MasterScripts On s.MasterScriptID Equals ms.MasterScriptID
                   Join svce In Var.db.CareSideA.Services On svce.SkillTargetID Equals scr.ForeignKey
                   Join p In Var.db.CareSideA.Peripherals On svce.PeripheralID Equals p.PeripheralID
                   Join sm In Var.db.CareSideA.ServiceMembers On svce.SkillTargetID Equals sm.ServiceSkillTargetID
                   Join sg In Var.db.CareSideA.SkillGroups On sm.SkillGroupSkillTargetID Equals sg.SkillTargetID
                   Where s.Version = ms.CurrentVersion And scr.TargetType = 1 And svce.PeripheralNumber = Value
                   Select New With {Key .Service = svce.PeripheralNumber,
                                    Key .ScriptName = ms.EnterpriseName,
                                    Key .Peripheral = p.EnterpriseName,
                                    Key .SkillMapping = sg.PeripheralNumber,
                                    Key .LatestVersion = s.Version,
                                    Key .Created = s.DateTime,
                                    Key .Author = s.Author}).ToList
        Return valQ
    End Get
    Set(value As IEnumerable)
    End Set
End Property

Now this does return results but they look like this:

Ideally I'd like to be able to do this:

<table>
For Each Item In Model.ByVDN
  Dim i = Item
    <tr>
      <td>@Html.DisplayFor(Function(m) i.Service)</td>
      <td>@Html.DisplayFor(Function(m) i.ScriptName)</td>
      <td>@Html.DisplayFor(Function(m) i.Peripheral)</td>
   Next

etc...

Answer 1

You can't pass about anonymous objects. Well, you can, but it is not strongly typed. You'll have to define a class with these properties, create IEnumerable of instances of that class and pass that Enumerable to the view. There is no other way.

UPD: see similar question: passing linq select query to the method