hi,
I have devart dotconnect 7.7.267. is there any settings, or any other way to make all updates act like "SELECT FOR UPDATE NOWAIT"?
in another words - every time we have dc.SubmitChanges dotConnect would check if the record is locked and return error right away, rather then wait for a long period of time until lock gets released.
thank you
SELECT FOR UPDATE
Re: SELECT FOR UPDATE
You can try performing your scenario via the ExecureQuery method.
For example:
Please tell us if this helps.
For example:
Code: Select all
Context.DataContext ctx = new Context.DataContext() { Log = Console.Out };
string sql = "select * from DEPT where DEPTNO = 1 FOR UPDATE nowait"; // select what you need
DEPT entity = ctx.ExecuteQuery<DEPT>(sql).FirstOrDefault();
entity.DNAME = "new name";
ctx.SubmitChanges();
Re: SELECT FOR UPDATE
thank you for your response.
I was hoping there is a way to do this with straight LINQ, without using inline SQL.
perhaps I should build an extension method or something.
thanks
I was hoping there is a way to do this with straight LINQ, without using inline SQL.
perhaps I should build an extension method or something.
thanks
Re: SELECT FOR UPDATE
We are sending you a sample project, which demonstrates a possible way to implement your scenario, to the e-mail address you have provided in your forum profile. Please check that the letter is not blocked by your mail filter.
Please tell us if this helps.
Please tell us if this helps.
Re: SELECT FOR UPDATE
I received your email. thank you.