ASP.NET MVC Web Application Using LINQ to SQL Classes

{

try

{

// TODO: Add update logic here

return RedirectToAction("Index");

}

catch

{

return View();

}

}

}

}

First of all add a namespace in the controller class.

using MVCUsingLINQToSQL.Models;

Now right-click on the Index method and click Add View and select View data class name view content.

Figure 9.

Add some code to show data in the list in the Index method.

public ActionResult Index()

{

var dataContext = new ProductsDataContext();

var products = (from m in dataContext.Products

select m).ToList();

return View(products);

}

And run your application; you will see all the records.

Now right-click on the Create method and click on Add View.

Figure 10.

From Create.aspx you must remove the ProductID paragraph because this is an auto-generated column.

Now add this code in the controller class for the Create method.

//

// GET: /Home/Create

public ActionResult Create()

{

return View();

}

//

// POST: /Home/Create

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Create(Product product)

{

if (ModelState.IsValid)

{

try

{

// TODO: Add insert logic here

var dataContext = new ProductsDataContext();

dataContext.Products.InsertOnSubmit(product);

dataContext.SubmitChanges();

return RedirectToAction("Index");

}

catch

{

return View(product);

}

}

return View(product);

}

Here is your Edit method code:

//

// GET: /Home/Edit/5

public ActionResult Edit(int id)

{

var dataContext = new ProductsDataContext();

var products = dataContext.Products.SingleOrDefault(x => x.ProductID == id);

return View(products);

}

//

// POST: /Home/Edit/5

[AcceptVerbs(HttpVerbs.Post)]

public ActionResult Edit(int id, FormCollection collection)

{

var dataContext = new ProductsDataContext();

var products = dataContext.Products.SingleOrDefault(x => x.ProductID == id);

try

{

// TODO: Add update logic here

UpdateModel(products);

dataContext.SubmitChanges();

return RedirectToAction("Index");

}

catch

{

return View(products);

}

}

Delete Method Code:

public ActionResult Delete(int id)

{

// Get movie to delete

var dataContext = new ProductsDataContext();

var productToDelete = dataContext.Products.First(m => m.ProductID == id);

// Delete

dataContext.Products.DeleteOnSubmit(productToDelete);

dataContext.SubmitChanges();

// Show Index view

return RedirectToAction("Index");

}

We are done with the LINQ to SQL Class here.