How to create a simple Local SQL database & insert values into it using C#?

Question

How to create a simple Local SQL database & insert values into it using C#? can any one provide me a sample code or project link.. i googled a bit, i am not getting how to do.. if you can advice it would be great

Answer 1

If you are creating a Desktop application, you can create a local Sql server Ce (Compact edition) database.

When you install Visual C# 2008 Express, It will automatically install SQL Compact 3.5 on your box.

Here is an excellent Getting started tutorial on the topic:

http://dotnetperls.com/sqlce

Answer 2

I would use SQLite. It's simple and it doesn't need any kind of installation, the full database it's only a file.