create windows application with database access
-
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?
cellardoor
-
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?
cellardoor
SQL Server Compact Edition[^] is what you need. (Express still needs to be installed.) Compact is just a couple of dlls that let you use a single .sdf file as a database. Similar limits to Express (4gig db limit etc) - but it is also missing stored procs. Then use this[^] to handle your data access and the whole data end of your application is done for you. Your other option if you don't actually need the databasey features of a database is to use a prevalence mechanism[^] that stores plain .net objects for you.
Mark Churchill Director Dunn & Churchill
-
SQL Server Compact Edition[^] is what you need. (Express still needs to be installed.) Compact is just a couple of dlls that let you use a single .sdf file as a database. Similar limits to Express (4gig db limit etc) - but it is also missing stored procs. Then use this[^] to handle your data access and the whole data end of your application is done for you. Your other option if you don't actually need the databasey features of a database is to use a prevalence mechanism[^] that stores plain .net objects for you.
Mark Churchill Director Dunn & Churchill
Thank you, I´ll try the SQL Server Compact Edition.
cellardoor
-
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?
cellardoor