Choosing proper database for a few users application

Posted by tomo on Stack Overflow See other posts from Stack Overflow or by tomo
Published on 2010-12-31T17:38:57Z Indexed on 2010/12/31 17:54 UTC
Read the original article Hit count: 239

Requirements:

  • tiny WinForms client app (C# 4.0, WinForms or WPF)
  • a few users working simultinausly
  • no database service at all - the whole engine as *.DLLs inside client apps
  • database available as shared folder on one computer
  • at least simple concurrrency checks
  • compatible with nHibernate or EntityFramework / NET 4.0
  • backup as simple as copying files from shared folder - assuming no running clients at the moment
  • no stored procedures/triggers required
  • data size - a few tables and a few thousands rows after 2 years

Nice to have:

  • user access rights
  • encrypted data

I'm trying to choose between:

  • MS Access
  • SqlLite
  • SqlServer Compact Edition.

Can you recommend which one should be the best for these requirements?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about database