Can I set the isolation level in the connection string?

Question

How can I set the isolation level of all my SqlCommand ExecuteNonQuery calls to be read uncommitted? (connecting to a SQL Server 2008 enterprise instance)

I am simply transforming static data and inserting the results to my own tables on a regular basis, and would like to avoid writing more code than necessary.

Answer 1

No, you cannot.

You need to explicitly define the isolation level when you start a transaction.

For more info on adjusting the isolation level, see the MSDN documentation on the topic.

Answer 2

No, you cannot.

And there is No way of changing the default transaction isolation level.

http://blogs.msdn.com/b/ialonso/archive/2012/11/26/how-to-set-the-default-transaction-isolation-level-server-wide.aspx