Udostępnij za pośrednictwem


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.

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

Tasks

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

Other Resources

Communicating with the Database (LINQ to SQL)