How to: Directly Execute SQL Commands

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


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