I wanted to do CRUD (create,Retrieve,Update and Delete) operations using
ASP.Net MVC 4 with ASPX view engine & Entity framework(.edmx file extension)
I wrote for Showing the data and Inserting it to the Database.
Please tell me how to do it for Update and Delete operations
NorthwindEntities obj = new NorthwindEntities();
public ActionResult Cateview()
{
ViewData["Cate"]=obj.Categories.ToList();
return View();
}
public ActionResult InsertCateview()
{
return View();
}
[HttpPost]
public ActionResult InsertCateview([Bind] Category objcate)
{
obj.Categories.Add(objcate);
obj.SaveChanges();
return RedirectToAction("Cateview", "Cate");
}
Jignesh TrivediPosted Apr 23, 2014, 12:16 AM
Hi,
Try code like....
public ActionResult InsertCateview([Bind] Category objcate)
{
if(objcate!=null)
{
using(NorthwindEntities objN = new NorthwindEntities())
{
objN.Categories.AddObject(objcate);
objN.SaveChanges();
}
return RedirectToAction("Cateview", "Cate");
}
}
public ActionResult UpdateCateview([Bind] Category objcate)
{
if(objcate!=null)
{
using(NorthwindEntities objN = new NorthwindEntities())
{
var oldObj = objN.Categories.Where(p=>p.Id == objcate.Id).FirstOrDefault();
oldObj.Name = objcate.Name;
objN.SaveChanges();
}
return RedirectToAction("Cateview", "Cate");
}
}
Hope this will help you.
vijay kumarPosted Apr 25, 2014, 12:10 AM
public ActionResult UpdateCateview([Bind] Category objcate)
var oldObj = objN.Categories.Where(p=>p.Id == objcate.Id).FirstOrDefault();
changed as below
public ActionResult UpdateCateview(int id, [Bind] Category objcate)
var oldObj = objN.Categories.Where(p=>p.Id == id).FirstOrDefault();
Is working now..
once again thank u
Regards
Vijay
Nimit JoshiPosted Apr 23, 2014, 3:13 AM
CRUD Operation in ASP.Net MVC Framework