如何更新数据中的行

原文:http://msdn.microsoft.com/en-us/library/bb399339.aspx

To update a row in the database

1. Query the database for the row to be updated.

2. Make desired changes to member values in the resulting LINQ to SQL object.

3. Submit the changes to the database.

Example

---

The following example queries the database for order #11000, and then changes the values of ShipName and ShipVia in the resulting Order object. Finally, the changes to these member values are submitted to the database as changes in the ShipName and ShipVia columns.

C#

VB

// Query the database for the row to be updated. 
var query =
    from ord in db.Orders
    where ord.OrderID == 11000
    select ord;

// Execute the query, and change the column values 
// you want to change. 
foreach (Order ord in query)
{
    ord.ShipName = "Mariner";
    ord.ShipVia = 2;
    // Insert any additional changes to column values.
}

// Submit the changes to the database. 
try
{
    db.SubmitChanges();
}
catch (Exception e)
{
    Console.WriteLine(e);
    // Provide for exceptions.
}