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

By local do you mean server-less database? Like embedded or in a file? Something like SQL Server Compact? microsoft.com/sqlserver/2008/en/us/compact.aspx — Jaroslav Jandek
– Jaroslav Jandek, Commented Feb 10, 2011 at 10:39
By local means, like simple sql file creation in hardisk and accessing data like that.. — Naruto
– Naruto, Commented Feb 10, 2011 at 10:43
Then that's exactly what I suggested. You can work with the database directly in Visual Studio (create DB, tables, modify, ...) ;) — Jaroslav Jandek
– Jaroslav Jandek, Commented Feb 10, 2011 at 11:19
i want to do it programmatically using C# functions.. is there a way? — Naruto
– Naruto, Commented Feb 10, 2011 at 11:28
It is. Check out msdn msdn.microsoft.com/en-us/library/ec4st0e3.aspx a sample to create the DB is here msdn.microsoft.com/en-us/library/… — Jaroslav Jandek
– Jaroslav Jandek, Commented Feb 10, 2011 at 11:32

Raghu · Accepted Answer · 2011-02-10 11:00:32Z

3

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

answered Feb 10, 2011 at 11:00

Raghu

2,7682 gold badges33 silver badges38 bronze badges

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

Comments

Rodrigo · Accepted Answer · 2011-02-10 10:45:08Z

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.

answered Feb 10, 2011 at 10:45

Rodrigo

612 bronze badges

Comments

Jaroslav Jandek · Accepted Answer · 2011-02-10 11:39:49Z

0

Sql Server Compact is a great embedded database. It is also fully documented on MSDN, see System.Data.SqlServerCe Namespace.

You can easily create and modify databases programatically, see SqlCeEngine.CreateDatabase Method.

You can download it on the SQL Server Compact Download Page.

answered Feb 10, 2011 at 11:39

Jaroslav Jandek

9,5831 gold badge31 silver badges30 bronze badges

3 Comments

Naruto Over a year ago

Hey, CE for windows mobile right. SO can we use the same for desktop?

Jaroslav Jandek Over a year ago

@LLL: CE as in SQL Server Compact Edition, not Windows CE.

Naruto Over a year ago

oh.. Jaroslav Jandek Thanks..i will have look at it once.. Thanks again

Collectives™ on Stack Overflow

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

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related