How to create a program with its own database as a stand alone?

[Luxmee]

Hi all,

I want to write a program that has to be installed on people PCs. The program will have a database. What I want to know is how to install the database together with the program without having the user to do it himself.

E.g. a program like outlook has a databse inside it not on a server.

Please direct me in the right direction. A link to a tutorial or something simillar will be just great.

 

[JohnH]

Standalone applications (like Outlook) read and write data to files on the computers filesystem. Basics of .NET Framework File I/O and the File System

It is also easy to use Visual Studio to develop application with SQL Express, the integrated ClickOnce publishing system can install it automatically on client if needed.

 

[jmcilhinney]

You can also use an Access database if you want a relational database without a server and without having to create your own data file format. An Access MDB or ACCDB file is just another file that you install along with your app's binaries.

 

[jacky.goy]

I can suggest you use Firebird. You may embedded the client server along with your application, also if you prefer to have your application in network envirnment you may install the Firebird Server on the server. (And the best part, it's free)

 

[jmcilhinney]

SQL Server provides embedded and free server versions also.