ASP.NET: Thread-safety in a file-based database -


i have worked bit asp.net before. using ms sql server store , retrieve data display in dynamic pages in 1 project started learn asp.net bit. start new project time store data in file-based database , say, access file. project hobby project , i'm not afraid of scaling problem because perhaps 3 users using application @ same time , no data traffic expected.

now , question: using ms sql database there no problem several users reading-writing db @ same time because db engine take care of this, using file-based database ado.net problem in case, right?

what mean, need take care of multiuser synchronization myself (using synchronization mechanism, lock, mutex, whatever) guarantee thread safety when working database or ado.net takes care of well?

should use perhaps singleton class data layer?

as fretje mentioned, ms access isn't db use web applications. assuming know there isn't special need in order use access db ado.net (other using right provider of course). ado.net handle you.

about having data layer singleton, not recommend that.


Comments

Popular posts from this blog

javascript - Enclosure Memory Copies -

php - Replacing tags in braces, even nested tags, with regex -