Last post Apr 14, 2015 08:24 AM by sugankris
Apr 14, 2015 06:38 AM|sugankris|LINK
I am having a problem with commit.
Here is the code where program stuck.
using (var transaction = DataEngine.Context.Database.BeginTransaction(IsolationLevel.ReadCommitted))
var createResult = DataEngine.Context.Customer_Modify(BusinessID, cutomerName,usermodified);
catch (Exception ex)
// Attempt a rollback
catch (Exception nex)
After running the above code, I check the variable query and found an exception
The underlying provider failed on Open.
Connection between server and computer is normal
I can login to the database with username and password
I have checked the security settings in database (SQL Server) that permission has been granted .
I can able to 'Insert' records but not 'Update'
Why does this exception happen? I'm using .net 4.5
Apr 14, 2015 07:52 AM|PatriceSc|LINK
You should have an inner exception with what happened... nex.GetBaseException().Message might give a more accurate picture...
Apr 14, 2015 08:24 AM|sugankris|LINK
Thanks for the Reply, the innerException is:
"Value cannot be null.\r\nParameter name: connection"