How to set XACT_ABORT within ADO.NET

Question

How can I set XACT_ABORT to ON (or OFF) from within ADO.NET ?

Answer 1

Execute SET XACT_ABORT ON or SET XACT_ABORT OFF.

Answer 2

There is no client setting: in SQL As Remus said.

SET XACT_ABORT is not a property of the connection, command or transaction and can be set/unset at any time in SQL Code. There is no ado.net options for SET NOCOUNT ON etc.