c# - Accessing MDF file thread safety -
is mdf file access (when attached sqlexpress) thread safe?
i have local mdf file deployed along wpf client application. i'm using mdf file persist client-specific settings. there may many threads selecting , updateing same rows @ same time , accessing file via sql connection provider simultanously.
now, i'm asking wether or not can treat thread syncronization same way remote sql server databases (just leave work sql connection provider) or have wrap db calls inside critical section?
thanks!
i'm confused, it's microsoft sql database running on database server manages table , row locking , conflicts long use optimistic concurrency in clauses when updating rows. example
update settings set = 'val' = 'old val'
so of course it's thread safe.
Comments
Post a Comment