create windows application with database access

juraj

19y2.9kSoftware Architecture/Engineering

I´m trying to create a windows application that will be able to store data in a database. Both the application and the database have to be in one installation package and the end user has to be able to use the application correctly without the need to install anything else(database server,...). Can anyone help me with this? Which kind of database should I use?

I was thinkink about using MSSQL 2005 Exress Edition and then just attached the .mdf file to the application, but I´m not sure if this is the best solution. Is it possible to access and work with .mdf file on a computer, that does not have the MSSQL server installed?

Or what is the best solution for this problem?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sanjay dobhal18y ago
Hi,

this is to ref from your mail,

U can try this through add database wizard in your application folder.

then u can install ur application with just one installer no need to install database seperately
Chongo19y ago
Your best bet is to use aSQLite database. It is a standalone file and has standalone viewers for looking at data if needed. You can interface in C# to it using free software that makes it look like an ado database connection. It is free fast and easy.

http://adodotnetsqlite.sourceforge.net/