Hi. I'm working with Sql Server Compact in my Visual Studio 2010 code. I'm trying to make a transaction with isolation level Snapshot, but I'm getting this error. Is this some kind of limitation to Sql Server Compact? A limitation to how I'm connecting
to my database?
This is the line of code the exception is raised on
using (DbTransaction transaction = DataContext.Connection.BeginTransaction(IsolationLevel.Snapshot))
And here is my connection to the sdf file
protected MyDataContext DataContext
if (dc == null ||
dc.Connection.State == System.Data.ConnectionState.Broken ||
dc.Connection.State == System.Data.ConnectionState.Closed)
dc = new MyDataContext(@"Data Source=Data\QuadrusMotorsData.sdf;");
Any insights at all would be appreciated.
View Complete Post