Cached data only / Offline mode 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;
Offline=true;QueryPassthrough=True;Cache Location=C:\cache.db;

SELECT statements will always retrieve data from the cache. DELETE/UPDATE/INSERT statements is not allowed and will throw an exception.