Caching data and metadata 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;Cache Metadata=true;

The table metadata will also be cached instead of retrieving it from the data source. This improves connection performance. Read more here →