I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.
I would like to achieve: 1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file. 2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
How can I achieve this?
