Accessing MDF file thread safety [closed]
I'm really confused, it's a Microsoft SQL database running on a database server that manages table and row locking and conflicts as long as you use optimistic concurrency in your WHERE clauses when updating rows. For example
update settings set A = 'val' where A = 'old val'
so of course it's thread safe.
MDF file is Main Database File.
You can't write to MDF file directly(theoretically),you are accessing through SQL Server engines and clients.
As for multiple SELECT
and UPDATE
you are relay on database transaction isolation levels(read commited,read uncommited,serializable,snapshots).