CData ADO.NET Provider for SharePointCaching data automatically

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]".

Connecting

This connection string (Caching data automatically using CData ADO.NET Provider for SharePoint) can be used for connections to SharePoint.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.