Deleting database data

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shweta Lodha7y ago
Accepted 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 Kumar7y ago
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 Jangid7y ago
hello Gearme,

please have use following link:

https://www.c-sharpcorner.com/UploadFile/3d39b4/simple-select-insert-update-and-delete-using-linq-to-sql/