Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Local database without sql server

I am creating a C# application that I will install on some low end pcs. All I can install on low end machines is .NET framework. I want to use some sort of database so that I can store information that application will be scraping from internet. Can anyone suggest me how to proceed about that ? I cant install any version of sql server.

Thanks.

like image 596
harrisunderwork Avatar asked Nov 21 '10 12:11

harrisunderwork


People also ask

Can I use SQL without a server?

You don't need to buy SQL Server, you need to create a SQL instance in it to use it.

Can you have a database without a server?

Yes… and No… depending on the context, that is. If you want to use somebody else's database you do not need any server in any meaning. But that “somebody else” will have to get a database server that will run the database software and give you the possibility to use the database.

Can you have a local SQL database?

An instance of SQL Server Express LocalDB is an instance created by a user for their use. Any user on the computer can create a database using an instance of LocalDB, store files under their user profile, and run the process under their credentials. By default, access to the instance of LocalDB is limited to its owner.

Can a database be local?

Local databases are usually faster than remote database servers because they reside on the same system as the database application.


3 Answers

Your best option is to use an access database. You won't need to install anything on the machine it is virtually like using a flat file that can be queried like a database :)

like image 153
Amila Avatar answered Oct 23 '22 02:10

Amila


SQLite seems to be the answer. http://www.sqlite.org/

like image 44
iDevlop Avatar answered Oct 23 '22 04:10

iDevlop


I recommend SqlServerCe 3.5, it's compatible with EF 4.0 and it's so easy to deploy, just 2 .dll files.

like image 5
Stefan P. Avatar answered Oct 23 '22 03:10

Stefan P.