Making and Submitting Data Changes (LINQ to SQL)

The topics in this section describe how to make and transmit changes to the database and how to handle optimistic concurrency conflicts.

Note

You can override LINQ to SQL default methods for Insert, Update, and Delete database operations. For more information, see Customizing Insert, Update, and Delete Operations (LINQ to SQL).

Developers using Visual Studio can use the Object Relational Designer to develop stored procedures for the same purpose. For more information, see Object Relational Designer (O/R Designer) and Object Relational Designer (O/R Designer).

In This Section

• How to: Insert Rows Into the Database (LINQ to SQL)
  Describes how to insert rows in the database by adding objects to the object model.

• How to: Update Rows in the Database (LINQ to SQL)
  Describes how to update rows in the database by updating objects in the object model.

• How to: Delete Rows From the Database (LINQ to SQL)
  Describes how to delete rows in the database by deleting objects in the object model.

• How to: Submit Changes to the Database (LINQ to SQL)
  Describes how to send object-model changes to the database.

• How to: Bracket Data Submissions by Using Transactions (LINQ to SQL)
  Describes how to include operations in a transaction.

• How to: Dynamically Create a Database (LINQ to SQL)
  Describes how to generate databases dynamically, and typical scenarios for this approach.

• How to: Manage Change Conflicts (LINQ to SQL)
  Describes techniques for addressing optimistic concurrency issues.