New feature in Visual Studio 2010: local database caching

If you are using Visual Studio 2010 already, you might have noticed a new feature when configuring your data sets using the Data Source Configuration Wizard: "Enable local database caching".

What does this new option provide? Shortly put, if you have an SQL Server installation on the network, but your application is a so-called occasionally connected one, then the network connection might not be available at all times.

In such situations, the local database caching feature will allow you to work normally with the application, but instead of using the network SQL Server, a local SQL Server embedded installation will be used. Then, once the network connection is again available, then data can be synchronized to the network database server.

Sounds useful? It is.