This documentation is archived and is not being maintained.

How to: Directly Execute SQL Commands (LINQ to SQL)

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");
Show: