[k0b13r]

Hi! I'm not sure if it's more C# or Databases related question, someone move my post if I missed the forum

I would like to ask if it is possible to "include" SQL Server (maybe some redistributable package or something?) to my desktop .NET (exactly C#) application? This app needs to store some data (added daily) and it's not possible to install "full" SQL Server on machine where it will be used (I mean, it's possible but I'd rather not install it there Is this possible in any way or I just have to use some database server in the Web? Thanks for replies!

[MentalFloss]

You can add a local database to your application via Add New. It's called "Local Database" and it should be rather noticeable.

Now, the database is a bit different from an installed version. It's the sql compact edition. You'll want to research the pros and cons of using it because "daily updates" might be stretching its usefulness.

[eclipsed4utoo]

MentalFloss, on 17 March 2010 - 09:45 PM, said:

You can add a local database to your application via Add New. It's called "Local Database" and it should be rather noticeable.

Now, the database is a bit different from an installed version. It's the sql compact edition. You'll want to research the pros and cons of using it because "daily updates" might be stretching its usefulness.

There is no con to writing data to a SQL Compact database on a daily basis. Mainly because thats the database type that Windows Mobile uses. So adding data all day everyday would cause no other issues that a normal database would have, except for size issues.

This post has been edited by eclipsed4utoo: 17 March 2010 - 08:03 PM

[EtherealMonkey]

Also, look at System.Data.SQLite @ http://sqlite.phxsoftware.com

Note:

Some people HATE SQLite with a passion (for personal reasons or reasons of dogma it seems).

Others LOVE it.

I will let you decide.

(I love it frequently and find few reasons to fault it in a standalone application).

HTH

[k0b13r]

Thanks a lot for your answers!