C# - Local SQL Database. Couple of questions!

How's everybody doing?

I'm in the process of coding my first bot. Then next step requires an sql database. I've been reading a lot of material the past few weeks and I still have some question.

I want the database to be a local database. It's going to consists of 3-5 tables. There's going to be a lot of reading. I'll be inserting large amounts of data once everyday or so.

Depending on the user, the amount of data stores could be very small or very large.

Now for the questions:

Which type of database should I go with? SQL CE, SQL Lite, or some other sql type?

Should I be worried about the database file becoming to large?

Thanks for any help!

Posted via Topify using iPhone/iPad

Go for SQL lite, it's tiny, widely used and fast as a local database. Plus your database will only be a file. Visual studio might even support it in Server Explorer. If it doesn't search for it in the online extension, I'm quite sure there is one for free.

Good luck.

I'll suggest you to use SQL Lite as it's very compact & yet fast. You'll be able to find a lot of tutorials to use and integrate in your C# application.

http://www.codeproject.com/Articles/22165/Using-SQLite-in-your-C-Application

Click to expand...

SQLite is great and fast with widely used language its database files are also cross platform compatible.SQLite is also simple to maintain

i would recommend sql, unless you require micro transaction speed there is very little difference in terms of however we would measure "speed"

sql has more commands, and you will find it easier to migrate to a decent db once you start using it more.

Go for SQL CE with Entity Framework 5.0.
You will not regret.