In my Relation i have two tables relation (one to many)
table country
Id (primary key)
Countryname
table City
Id (primary key)
Cityname
Countryid (forign key)
I have controller City have the following function
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using LinqProject.Models;
namespace LinqProject.Controllers
{
public class CityController : Controller
{
mytaskdbEntities db = new mytaskdbEntities();
// GET: City
public ActionResult List()
{
return View(db.Cities.ToList());
}
and in view of List as following
<body>
<div>
<table>
@foreach (var item in Model)
{
<tr><td>@item.Cityname</td><td>@item.Country.Countryname</td></tr>
}
</table>
</div>
</body>
What i need actually adding delete button to view of list of city
and i can delete city when click button delete
how to do deleting record by linq
the final result as following
USA NEWYORK DELETEBUTTON
USA WASHINTON DELETEBUTTON
FRANCE PARIS DELETEBUTTON
when click delete button for row USA NEWYORK it will delete
and remaining two record
USA WASHINTON DELETEBUTTON
FRANCE PARIS DELETEBUTTON