SQLite or SQL Server Compact project for .NET

Question

I need a simple built-in database for a relatively small database size (<100 MB, but in most cases <20 MB) and a maximum of 1-2 simultaneous users / connections on average. He should be able to protect / encrypt data using login.

Which database is best for work?

Answer 1

Sqlite

Pros
-
-
- XCopy ( )
-

- # → http://code.google.com/p/csharp-sqlite/

- C API ( )
- SQL
-
- ( )

SQL CE

Pros
- ( SQL Server)
- , ( )
- OLE DB (C/++) ADO.NET
-
- SQL ( )

- XCopy ( )
- .. ?

, , SQL CE, ?

Answer 2

SQLite .

.

SQLite .NET ( , - SQLite , , , SQLite , , , . concurrency .

, SQLite SQL .

, . ? concurrency? ?

Answer 3

.

SQL Server, SQL Server Compact Edition, , . , .

Answer 4

They are both great IMO. But, when possible, I try to stick with MS material when working in .NET. This assumes that a budget is in place to do this ... but since you are looking at SQL Server CE and Sqlite, they are both free. Both will support EF, but I would suggest that Sql Server CE will have better support in most areas.

Also, have you considered db4o browsing for an inline solution? A pretty nice NoSQL solution ... and it's also free.