Caching data automatically using CData ADO.NET Provider for SharePoint

Connection string

This CData ADO.NET Provider for SharePoint connection string can be used for connections to SharePoint.

URL=http://sharepointServerName/;User=myUsername;Password=myPassword;
Cache Location=C:\cache.db;Auto Cache=true;Offline=false;

To retrieve data from the cache, add "#Cache" to the table name. For example, to query cached data from the "Calendar " table, execute "SELECT * FROM [Calendar#Cache]".