hallo, I am new in mvc and linq. I've 2 table in relation many to many: 1)employe 2)device
Selecting an employe I'd like to see his devices:
-Marco -Franco Selecting Marco should appear the devices associated to him.
My code (not work):
Nel controller:
public ActionResult VediDevice(int id)
{ Impiegato impi = new Impiegato(); List<Device> ListDevice = new List<Device>(); using (DatabaseMVCCOntrolsEntities db = new DatabaseMVCCOntrolsEntities())
{
ListDevice= db.Devices.Where(u => db.ImpiegatiDevice.Any(m => m.impiegatiID == id)).ToList(); //<---???
//or
ListDevice= db.Devices.ToList().Where(u => u.item.Any(m => m.impiegatiID == id)).ToList(); //<--??
}
return View(ListDevice);
}
In device.cs I added:
List<ImpiegatiDevice> item{get;set;}
VediDevice.cshtml:
@model List<MVCControlToolkit.Models.Device>
@{
ViewBag.Title = "VediDevice";
}
<h2>VediDevice</h2>
<table class="table table-striped table-condensed">
<tr>
<th>
NOME
</th>
</tr>
@foreach (var item in Model)
{
<tr>
<td>
@Html.DisplayFor(modelItem => item.nome)
</td>
</tr>
}
</table>
Not work.
What should I do?
Thank you
Ale