With the 4.3 Version of the Provider I am not able to call SaveChanges() in Entity Framework.
It was working in 4.1 / 4.2 when setting the IsolationLevel to NoCommit in the connection string:
But this no longer works, as it returns the following:
System.ArgumentException: The specified isolation level is not supported.
I tried setting different IsolationLevels all of which either returned the error above or the following:
SQL7008N "table_name" in "XXXXXX" not valid for operation.
Is there a solution / workaround for this in 4.3?
As the KB Article suggests you need to add Isolation level=None in your connection string. Have you tried that?
If not can you please give it a try.
In any case, please share you connection string with us along with ADO.NET Trace file. You can create the Trace file by adding "Trace File=c:\temp\adotrace.txt;Enable Trace=1;" in your connection string.
This additional information will help us understand why "no commit" was working for 4.2 and my not be working for 4.3.
Thank you for your reply,
especially for showing me how to create the trace file, which will be very helpful for debugging.
Isolation levels None and No Commit gave the same results.
I have attached two trace files, one for the 4.2 version currently running on a server and one for the 4.3 version running locally on my development machine.
In each I am reading data from a table (works for both) and trying to insert a new record which works in 4.2 but throws an error in 4.3
[View:/cfs-file/__key/communityserver-discussions-components-files/16/adotrace_5F00_4_5F00_2.txt:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/16/adotrace_5F00_4_5F00_3.txt:320:240]