Geek Answers Handbook

Fast local database

I have a desktop application that talks about soap on a server. The connection is very slow, so I want to load a lot of data ahead and query from my local database. I want this local data to be saved after the application is closed, so for this the best way., Are there any good products / examples for this., There are about 25 tables that I cache.

+6
c # database caching
source share
7 answers

SQLite is great for this. A couple of years ago, I wrote a smart client application, where I supported a local cache so that users could use the application offline. I used SQLite and had no problems, it is very small, quickly saved, and most modern ORMs support it. (I used NHibernate)

http://www.sqlite.org/

+14
source share

Berkeley DB is a good standalone database. You should also consider ESENT , which is built into windows. Here is a post from Ayende.

+3
source share

The H2 database can also meet your needs. Microsoft offers a compact version of SQL Server: SQL Server Mobile Edition . If SQL Server and TSQL are your thing, this might be a good choice.

+2
source share

You can always use an access database, as a rule, it’s quite simple to enter the .NET application and does not require installation or configuration of the server on the client.

+1
source share

Consider using Firebird, I believe that they also have the ADO.NET extension.

0
source share

I would consider SQL Server Express, or even SQL Server Compact Edition, which works with individual database files such as Access. Despite this, it is still SQL Server.

0
source share

You might also consider Apache Derby , which is used in the Sun Glassfish Java EE server.

0
source share

More articles:


All Articles