Edit

Share via

How to: Directly Execute SQL Commands

  • Article

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