Geek Answers Handbook

What is a good "mobile" .NET database supporting LINQ?

I am refactoring the application and I decided to use a mobile / embedded database.

I read about SQL Server Compact Edition, but I was wondering if you knew about any other databases that could be used and did not have huge download sizes, since my current application is about ~ 2 MB (installer). SQLite would be nice, but the AFAIK GSOC implementation of LINQ-to-SQLite is currently quite difficult.

Thanks!

+6
c # linq embedded-database
source share
3 answers

VistaDB and (as you mentioned) Sql Server Compact Edition are two small options for the embedded database. Sql Server Compact Edition can be used with Linq to SQL or Entity Framework. I believe VistaDB can be used with the Entity Framework.

Also, if you do not need a relational database, you can consider db4o . Rob Conery writes about it here .

Hope this helps!

+5
source share

I tried db40 once (not a compact edition) - this is a database of objects. However, depending on your needs, this can be a pretty convenient thing to use. They note that they support linq even for the compact edition: http://www.db4o.com/s/compactframeworkdb.aspx

+7
source share

I have not used it myself, but you can watch BlackFish . However, I'm not sure about Linq support, but Delphi supports Linq so that it can. Another may be Embedded Firebird - again, not sure about the Linq side.

0
source share

More articles:


All Articles