12

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.

Improve this question

5 Answers 5

Reset to default
11

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

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

SQLLite is a simple and quick (albeit not fast) solution. You can use a lot of management consoles to manage it, even some handy Firefox extensions, I use SQLLite manager: addons.mozilla.org/it/firefox/addon/5817
Can I deploy with application itself ? I mean application starts and deploy sqllite if not already present ?
10

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 :)

Improve this answer

3 Comments

I think I would go with your solution for the time being.
is MS Access still an option in year 2022? ;)
I would have to disagree with this as a solution. Dependency on an MS Office product is not ideal.
5

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

Improve this answer

2 Comments

By using SQL CE you would also be in a position where you can easily upgrade to a SQL Server implementation if you wanted.
Actually, my requirement does not require upgrading to SQL server at anytime but thanks for the suggestion though :)
4

VistaDB, SQLite, Compact Edition of SQL Server, MS Access, Firebird... the options are many and a list of them can be found here http://en.wikipedia.org/wiki/Embedded_database

Improve this answer

Comments

1

You can try SQLite.

There is a C# wrapper here.

Improve this answer

1 Comment

The wrapper link is not working anymore. Can you relink it maybe?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.