Old VB6 Code that needs to be converted:

```
'DB Connection
Set Conn = New ADODB.Connection
Conn.ConnectionString = sConn
Conn.Open sConn
Conn.BeginTrans

'Recordset
Set rsPrice = New ADODB.Recordset
rsPrice.CursorLocation = adUseClient
rsPrice.CursorType = adOpenKeyset
rsPrice.LockType = adLockBatchOptimistic
rsPrice.ActiveConnection = Conn

```

What would be the exact equivalent of this in C# .NET 3.5 Linq to SQL? I remember reading somewhere that using System.Transactions would require having MTS on the backend, but my memory is fuzzy this morning.

**EDIT:**

I could not find a direct match for CursorLocation, CursorType, and LockType up with the new APIs, which is the source of my confusion. I am familiar with TransactionScope, but I do not know if the defaults of TransactionScope are acceptable or if I'm making a bone-headed mistake by trusting in them. The database is SQL Server 2005.