how to make delete row from table using linq
-
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>
@foreach (var item in Model)
{}
@item.Cityname
@item.Country.Countryname
</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
-
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>
@foreach (var item in Model)
{}
@item.Cityname
@item.Country.Countryname
</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
You can add button control with command 'delete' in the buttons. When you click pass the id of city to be deleted to the controller. In the controller you need to receive two parameters command and id of the city. What's your issue ?