Deleting database data

Question

Friends, How can I delete data of a table using LINQ. Sample code or online tutorial will help.

Shweta Lodha · Answer

Graeme Pariot, Please have a look at below link, almost complete sample is given: https://social.msdn.microsoft.com/Forums/en-US/ae983acc-e434-4058-be6a-59375fc29cb5/combobox?forum=winforms

Suraj Kumar · Answer

To delete a row in the database 1. Query the database for the row to be deleted. 2. Call the DeleteOnSubmit method. 3. Submit the change to the database. Example This first code example queries the database for order details that belong to Order #11000, marks these order details for deletion, and submits these changes to the database. // Query the database for the rows to be deleted. var deleteOrderDetails = from details in db.OrderDetails where details.OrderID == 11000 select details; foreach (var detail in deleteOrderDetails) { db.OrderDetails.DeleteOnSubmit(detail); } try { db.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); // Provide for exceptions. } To know more in details follow the below link https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/how-to-delete-rows-from-the-database

Gajendra Jangid · Answer

hello Gearme, please have use following link: https://www.c-sharpcorner.com/UploadFile/3d39b4/simple-select-insert-update-and-delete-using-linq-to-sql/

Deleting database data

Answers (3)