snapshot isolation kentico v.8.1.17

Carlos Granados asked on March 16, 2021 21:58

Hi can I enable snapshot isolation for my database in version 8.1.17?

Correct Answer

Dmitry Bastron answered on March 17, 2021 10:47

Hi Carlos,

Kentico is using ADO.NET under the hood to work with the database. According to MS docs, it should work. However, you can't customize SqlTransaction call, therefore you'd also need to configure READ_COMMITTED_SNAPSHOT ON option (refer to MS docs above). Is there any specific reason you need it? If you have troubles with concurrent work with the database via Kentico API this may not help and probably would be easier to resolve this on code level.

0 votesVote for this answer Unmark Correct answer

   Please, sign in to be able to submit a new answer.