How to insert update and delete using ling in asp.net

Question

Hi.. how can we (insert,update,delete and select) using linq with c# in visual studio 2008.

Pravin More · Answer

Hi Kanhialal, here is sample code for insert ,update ,delete.....try it //Delete public void DeleteProduct(int productId) { using (MyDataContentDataContext context = new MyDataContentDataContext()) { Product currentProduct = context.Products.FirstOrDefault(p => p.ProductId == productId); context.Products.DeleteOnSubmit(currentProduct);context.SubmitChanges(); } //Insert public void AddProduct() { Product product = new Product(); product.Name = "Product3"; product.Description="This is product 3 Description"; product.Price=10; using (MyDataContentDataContext context = new MyDataContentDataContext()) { context.Products.InsertOnSubmit(product); context.SubmitChanges(); } } //Update public void UpdateProduct(int productId, string name, string description, double price) { using (MyDataContentDataContext context = new MyDataContentDataContext()) { Product currentProduct = context.Products.FirstOrDefault(p => p.ProductId == productId); currentProduct.Name = name; currentProduct.Description = description; currentProduct.Price = price; context.SubmitChanges(); } } Thanks, Pravin.

Satyapriya Nayak · Answer

Hi Kanhialal, Please refer the below link http://www.dotnetbips.com/articles/56f8f29d-2617-4f99-a8b4-977703ebf780.aspx Thanks

How to insert update and delete using ling in asp.net

Answers (2)