I'm looking for a database system to use with c#. I've mostly used SQL for now, but, this is a small applicaiton I'm gonna to create, which:
-Runs at max 1-2hours each day(so I don't want to have a SQL Server running all the time) -Will be installed on an usb key(only requirement has to be to have .net 4.0 installed), so it has to be nomade.
What can you advise me? I search a little, but I don't how this kind of database are called.
Well, i'd use a file-based "portable" database like:
Sqlite (I used this provider in the past and it works well, but you have quite a bunch of options).
You can look at the embedded version of Firebird
Firebird have more SQL function than SQLLite which also be a good choice but you can more easily to switch to a full version of the server
The embedded version is an amazing variation of the server. It is a fully featured Firebird server packed in just a few files. It is very easy to deploy, since there is no need to install the server. It is ideal for CDROM catalogs, demos or standalone desktop applications.
Here you can check Entity Framework support
