Transaction ReadOnly parameter does not work in the OleDb Provider [Archive]

View Full Version : Transaction ReadOnly parameter does not work in the OleDb Provider

GersonK

12-17-2006, 05:03 PM

Is the Transaction ReadOnly parameter does not work in the OleDb Provider? Actually, the only Transaction parameter that is working is NoRollbackFor and RollbackFor.
Is a bug or the OleDb doesn't support these features?

Mark Pollack

12-25-2006, 09:23 PM

Hi,
The ReadOnly setting is generally for ORMs that can make optimizations based on a second level cache, so it isn't supported for oledb.
Mark