How to: Directly Execute SQL Commands

Assuming a DataContext connection, you can use ExecuteCommand to execute SQL commands that do not return objects.

Example

The following example causes SQL Server to increase UnitPrice by 1.00.

db.ExecuteCommand("UPDATE Products SET UnitPrice = UnitPrice + 1.00");

    db.ExecuteCommand _
("UPDATE Products SET UnitPrice = UnitPrice + 1.00")

See also

• How to: Directly Execute SQL Queries
• Communicating with the Database