How to turn off triggers while using LinqToSQL

问题:

I have DB table with update trigger (to track history of changes). I want to use LinqToSql to do large changes on that table. But to do that fast I have to: turn off trigger, make changes and turn on trigger.
Is there any way to enable/disable triggers using LinqToSql?

回答1:

you would have to use the following from msdn doc

DISABLE TRIGGER { [ schema_name . ] trigger_name [ ,...n ] | ALL } ON { object_name | DATABASE | ALL SERVER } [ ; ]

see also this question on how to execute the above syntax (or any sql) via the DataContext